Hi,

I tried the formula but I get the following
Euro 1
Pound 2
SEK N/A
DKK N/A
NOK 5
PLN 6

It seems that the formula doesn't like SKE or DKK ??

"Niek Otten" wrote:

Hi Andy,

Your question is not very precise..:-)

However, try this:

VLOOKUP(B2,data!$B$67:$C$72,2,FALSE)

Post again in this thread if that doesn't help, and specify your data

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"AndyB" wrote in message ...
| 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