Match Formula

[Patcheen]

im using this formula to match dates but its not matching exactly its out by a few days

=IFERROR("A "&MATCH(B4,'Shirt Database'!$G$2:$G$60000,0),"")

b4 is the date im trying to match in 'Shirt Database'!$G$2:$G$60000 but as i say its not doing so its out by few days example b4 could be any date so im gonna use 04/05/91 but it returns 24/3/91 as i say it is only out by few days

 

[EdNerd]

Well, now that the MATCH part is correct, you can plug that back into your original formula.
But MATCH does NOT return the VALUE in the cell - only the POSITION of the cell in your search range.
If you want the data value contained in the cell, you can use INDIRECT:
=INDIRECT("'Shirt Database'!$G"&(MATCH(B4,'Shirt Database'!$G$2:$G$60000,0)+1))

 

[Patcheen]

that returns the date an not the location but thank u

 

[Marcelo Branco]

that returns the date an not the location but thank u

What exactly you mean by "location"? The row number of the cell where the date is found?

M.