G
Guest
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
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