Forum Discussion
Solved
Update Prices in multi-currency pricelist
Hi Excel-Community,
We're in the process of updating our current multi-currency pricelist with the new prices for 2018.
Following is an example of the expected result.
This being said we don't arrive to create a multiple lookup to match the Part# with the Currency.
Could anybody help us how we can get this done?
Many Thanks,
Ben
Hi,
You can use one of the below formulas:
=VLOOKUP(B2,$G$3:$I$6,IF(A2="XY",2,IF(A2="XYZ",3,NA())),0)
=INDEX($H$3:$I$6,MATCH(B2,$G$3:$G$6,0),MATCH(A2,$H$2:$I$2,0))
Please find the attachment to test it!
2 Replies
Hi,
You can use one of the below formulas:
=VLOOKUP(B2,$G$3:$I$6,IF(A2="XY",2,IF(A2="XYZ",3,NA())),0)
=INDEX($H$3:$I$6,MATCH(B2,$G$3:$G$6,0),MATCH(A2,$H$2:$I$2,0))
Please find the attachment to test it!
Hi, this was exactly, what i was looking for - thank you so much!!!
