How to match 2 prices
Gmata wrote:
I am trying to Match 2 prices i have 4 columns.
I have item number for both prices on 4 columns
for example
ITEM # retail price ITEM # wholesale PRICE
123 $20 543 $12
321 $14 123 $18
543 $30 321 $7
Now i need to match the prices by item number so i have to columns: retail
and wholesale with the correct prices. Thanks
Use VLOOKUP
If your example data is in columns A:D, this formula in a spare column
will return the wholesale price for the item# in column A:
=VLOOKUP(A2,C:D,2,FALSE)
|