Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
dynamic combo boxes | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions |