vlookup - sorry!

[stoke]

sure you guys must be tired of these:

i have data in a range - b2:10
with corresponding data alongsisde c2:c10
in f2 i have data that i want to lookup in b2:10 and return the corresponding data from c2:c10 into g2

i have:
=VLOOKUP(F2,B2:B10,2,FALSE)
and get #N/A

clearly i'm doing something wrong, but thought i'd followed the guidelines........

Thanks all,

 

[stoke]

Solved guys,
i realised that it was recognizing the data, as it was imported and p'prefixed by '.
Data cleansed it works a treat.

 

[mudstuffin]

Stoke,

You could also anticipate getting any further #N/A error values by using something like this:-

=IF(ISNA(VLOOKUP(F2,B2:C10,2,FALSE)),"No Match",VLOOKUP(F2,B2:C10,2,FALSE))

It looks a bit tidier if there is no match.

Regards,


mudstuffin.

 

[stoke]

Excellent, Thanks mudstuffin.