How to multiply a certain value based on the country criteria

Hello everyone,

I'm trying to come up with a formula that multiplies the exchange rates vs the input on Column B in table BrandV_T based on the country written in cell B2.

Is there a simple way to accomplish this? Attaching an example work book.

Thanks in advance,
D2S

Try this in C5:

=VLOOKUP($B$1,ExchangeRateV_T,2,0)*BrandV_T[[#This Row],[Value]]

You might need to widen the column.

Hope this helps.

Pete

Thank you Pete it works.

Would you know the workaround using index match so make the calculation less heavy?

D2S

Here's how to use INDEX/MATCH instead of VLOOKUP:

=INDEX(ExchangeRateV_T[Rate],MATCH($B$1,ExchangeRateV_T[Country],0))*BrandV_T[[#This Row],[Value]]

but I doubt there will be a major difference in the time taken.

Hope this helps.

Pete

Works.

Thank you!