| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box and VLOOKUP
My dropdownlist is in A2 and this is my formula:
=VLOOKUP(A2,sheet2!A1:E22,COLUMNS(A:B),0) I know how to make a combo box dropdown list, thanks to you guys. Q : How can I use the combo box dropdown list and look up in sheet 2 ( as formula) in other words : INSTEAD of A2 dropdown I'like combo box dropdown and still VLOOKUP for the other information. THANKS -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo box corrupting VLookup function | Excel Discussion (Misc queries) | |||
| vlookup & combo box charts | Charts and Charting in Excel | |||
| Offset And Vlookup Combo Help!! | Excel Worksheet Functions | |||
| vlookup from a combo box? | Excel Discussion (Misc queries) | |||
| Vlookup from Combo Box | Excel Discussion (Misc queries) | |||
Threaded Mode
