Update Prices in multi-currency pricelist

[Benjamin Aebischer]

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

[#2 · Accepted solution]

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!

[#3]

Hi, this was exactly, what i was looking for - thank you so much!!!