Excel 2007 : vlookup for upc to determine size

**silent1643** · 01-17-2011, 11:36 AM

I have some EDI data that i received (electronic orders) that did not have the size information within the data - how can i cross reference my UPC FILE/SHEET to determine the size information?

here is sheet 1 - see highlighted
\1

here is sheet 2 - my upc codes with sizes
\1

Uploaded with ImageShack.us

**NBVC** · 01-17-2011, 11:41 AM

You can populate a Pivot table with a Vlookup,

You will have to update the original table to show the items and then redo/refresh the Pivot table.

Btw... please attach all files directly here, not at 3rd party sites.. and do not show pics of excel files.. download sample files we can see and work with.

**silent1643** · 01-17-2011, 11:45 AM

Originally Posted by NBVC

You can populate a Pivot table with a Vlookup,

You will have to update the original table to show the items and then redo/refresh the Pivot table.

Btw... please attach all files directly here, not at 3rd party sites.. and do not show pics of excel files.. download sample files we can see and work with.

thanks i have the edi data as a pivot table (sheet 1)
its just getting the "blank" sizes to cross reference on the UPC sheet