Vlookup not working - data format problem

Posted by AnonymousUser PM | on Fri, 07/07/2006 - 02:01 39528 5 comments | report

When searching a list for data using lookup functions excel does not match like values because (I assume) the format of the cells is not the same. When the format has been changed to match the other format the lookup still appears as N/A. Is there a way around this problem, other than retyping?
Andrew Hepworth

Comments

There are 5 comments. Login or register to view them.

Index & Match does it for me

mattsmith2 | Mon, 28/10/2002 - 15:00

V Lookup

AnonymousUser | Mon, 28/10/2002 - 14:45

Mmmm...

neileg | Mon, 28/10/2002 - 13:03

Don't use IF

AnonymousUser | Mon, 28/10/2002 - 14:51

I think this will do it ...

AnonymousUser | Mon, 28/10/2002 - 14:08