Vlookup from Combo Box
 

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

If it's a Combo Box from the Control Toolbox toolbar, you
can set the "LinkedCell" property (right-click on the
combo box and go into "Properties") to a worksheet cell.
When the user makes a selection in the combo box, the
cell return that value. Link your VLOOKUP to that
cell...VLOOKUP(A1,---,---,---)

If it's a combo box is from the Forms toolbar, click on
the combo box, go into Format Control, Control tab, and
fill in a worksheet cell reference in "Cell Link".

HTH
Jason
Atlanta, GA

-----Original Message-----
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,Currenc y!
B18,FALSE)

Any help would be much appreciated.

Thanks
ACase
.

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