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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sliding scale for Mark Up 0
VLOOKUP and IF together 3
With F1 value, look at A, if match or partial match return B 5
INDEX MATCH AND ?? 2
compare and return a value from another worksheet 3
Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
Find matching records in two tables using mulitiple criteria 1
using the same formula for entire rows 1

Back
Top