I'm trying to do a VLOOKUP where the user chooses a currency in one cell B2
Then the VLOOKUP should fetch the exchange rate and put it in to other cells
D6:D12 for calculations.
It's not working :-(
Table has 'test' values in it.
Euro 4
Pound 6
SEK 6
DKK 4
NOK 5
PLN 6

VLOOKUP(B2,data!B67:C72,2) returns
Euro 1
Pound 2
SEK 3
DKK 4
NOK 5
PLN 6