| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo problems
G'day
I am setting up an Excel spreadsheet to give fishing club competition results and have a list of eligible species in column A and their relevant fight factors in column B. I have placed a Combo box with the fish from A to MatchEntryComplete on typing, and now want to be able to have the relevant fight factor show in cell next to Combo Box when fish is chosen. I'm only new AND from Oz, so please be gentle lol Thanks! Geoff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo problems
Assuming the source reference table is in Sheet1's cols A and B (FishSpecies
- FightFactor), and the combo's link cell is in A2 (in Sheet2), you could place in B2: =IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0)) -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "Geoff" wrote: I am setting up an Excel spreadsheet to give fishing club competition results and have a list of eligible species in column A and their relevant fight factors in column B. I have placed a Combo box with the fish from A to MatchEntryComplete on typing, and now want to be able to have the relevant fight factor show in cell next to Combo Box when fish is chosen. I'm only new AND from Oz, so please be gentle lol Thanks! Geoff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
| combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
| Combo Box List Problems | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Linear Mode
