How to match 2 prices

  • Thread starter Thread starter Gmata
  • Start date Start date
G

Gmata

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
 
Hi,

You can use the vlookup formula. Just keep in mind that the column index
will vary. For extracting the retail price, use 2 as the col_index. For
extracting the wholesale price, use 4 as the col index.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top