Having a very hard time getting Vlookup to work when using UPC codes.

[forestavekids]

Hi all,

Have UPC codes that I am trying to use a vlookup function for.

The vlookup is in column X, based on the data in column Q. Data source for vlookup is in columns AA, AB.

Please see attached.

[protonLeah]

data in Q are text (mostly), while that in AA is numeric. Try:

Please Login or Register  to view this content.

[azumi]

Hope this helps