VLookup prob (2002 sp1)

[andrewmcs]

Hi,

I'm trying to do a vlookup (See attached example)

On Main sheet, in cell h2, I'm trying to enter a vlookup command that will return the IP Number (from lookup sheet, column [img]/forums/images/smilies/cool.gif[/img] where the barcode number thats entered on g2 main sheet is contained within column a on lookup sheet.

I'm going daft with this one - any help much appreciated.

Regards,

amcs

[reimer]

amcs,

Column G on sheet main is entered as numbers and the column A on sheet lookup is all entered as Text.
I think you need to have both as Numbers or both as Text. Apples and Oranges do not mix well.

Chuck

[maxflia10]

The barcode entered in G2 is not in your Lookup table.

Better to add false to the argument for an exact match

=VLOOKUP(G2,Lookup!A2:B19,2,0)