anything in Excel...

It's Excel-o-lozy...

vLookup Eror - Two cells with same data but vLookup not working.

www.Excelolozy.com - On a quick look, two cells appear to be same but vLookup still gives an error. Try A1=B1 (where A1 and B1 are data cells) which still will give an error.

Reason can be of two types...

Type 1 is numeric and text difference... that I'll discuss later.

Type 2 is Space issue...

Check if there is a trailing space at end of text.
NO???

Check if there is a double space in between the text.
NO???

Last option is to check following :
Space visible in both cells is not space...
BUT actually....
in one cell there is Space
and in other cell a Space look-a-like Character is there.

So all you have to do is Copy this character, find, paste it and replace with space.

Magic???

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com