'RIGHT', 'LEFT' in a VLOOKUP
If your SKUs are unique (i.e. the last 5 digits of the UPC are also
unique), then you might be able to do it using wildcard characters
like this:
VLOOKUP ("*"&SKU, 'Sheet with UPC information'! UPC Column:Price
column, 2, false)
It depends on whether your UPCs are proper numbers or text values.
Hope this helps.
Pete
On Mar 13, 5:00*pm, RJB wrote:
I have a table of five digit SKU numbers that I need to cross-reference with
a list of UPC numbers and sales data.
The last five digits of the UPC number are the SKU number.
So my VLOOKUP is basically
VLOOKUP (SKU, 'Sheet with UPC information'! UPC column:Price column, 2, false)
To make that work, I need to actually add a column BEFORE the UPC column
that's really RIGHT (UPC Column, 5).
But I have lots of files, and don't want to save changes to them (they're
not mine).
Is there a way to do the VLOOKUP in a way that's essentially,
VLOOKUP (SKU, 'Sheet with UPC information'! RIGHT (UPC Column,5):Price
column, 2, false)?
|