| 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 |
| 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 | |||
Threaded Mode
