Vlookup from Combo Box

[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

 

[Jason Morin]

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

 

[Guest]

Perfect - Thank YOu