Neik,

Further to previos posts, the original formula actually works,

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

I had a couple of spaces in my table before DKK and SEK

Because I uesd 1 list for my validation and another for the VLOOKUP I needed
to have exactly the same text in both lists.

Thanks again
AndyB

"Niek Otten" wrote:

Probably superfluous, but anyway:

<On the 'Data' tab I have B67:B72 is a table called "currency"

No. It's A67:A72

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



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