Perfect - Thank YOu

"ACase" wrote:

Hello,

I am trying to use the Vlookup function from a Combo Box.

The combo box will contain currencies (USD, JPY, EUR). Once a user selects
a currency, the lookup will use that currency to find the exchange rate from
a table.

Something like this
=VLOOKUP("Forms.ComboBox1",Currency!A1:B4,Currency !B18,FALSE)

Any help would be much appreciated.

Thanks
ACase