Thread: VLookup with different criterias

Hi,

I have one data table with that contains my data rows with value, date and currency.

I have a second table where I have my exchange rates.

I need a formula in the first table that depending on the date and currency code, returns the correct currency rate for that particualr row.

1st table
Period/Curr/Amount/
Jan/GBP/3000
Jan/USD/1000
Jan/EUR/1500
Feb/GBP/3000
Feb/USD/1000
Feb/EUR/1500

2nd table
Currency in column header GBP/USD/EUR
Months on rows
And rates in the matrix between them

So I need a new column in the first table, that gets the correct rate from my currency table depending on the currency code and month.

Any ideas?

Use

=INDEX(Sheet2!$A$1:$D$20,MATCH($A2,Sheet2!$A:$A,0),MATCH($B2,Sheet2!$1:$1,0))

Bob, can you share a link where I can read about INDEX function and also MATCH function or you can explain how this work.

Thanks, I got it!