On the 'Data' tab I have B67:B72 is a table called "currency"
The VLOOKUP uses B67:B72 with the vlues next to it in C67:C72
B67:72 C67:72
Euro 1
Pound 2
SEK 3
DKK 4
NOK 5
PLN 6

The input tab is called 'options'.
It has a drop down list in cell B2, Validate list =Currency.
In cell E4 I have =VLOOKUP(B2,data!$B$67:$C$72,2,FALSE)

Hope this helps


"Niek Otten" wrote:

What is your formula exactly and what is your data/are your values? B2 and B67:C72?
Why do you get a table of results; do you have a table of formulas? What formulas? What lookup values?

Please be more precise

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



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