Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup with combo box
I have a spread sheet were I was using a drop down list and was using data
validation and vlookup to populate data in other cells. =IF(D6="","",VLOOKUP(D6,tablet!A:C,3,FALSE)). I wanted to use a combo box so the user to add data to the table. When I made the combo box and used the drop list I was unable to populate the other cell using the formula I had. Can this be done Thanks for your help. Larry |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup with combo box
Did you link the combobox to a cell?
-- ** John C ** "Larry" wrote: I have a spread sheet were I was using a drop down list and was using data validation and vlookup to populate data in other cells. =IF(D6="","",VLOOKUP(D6,tablet!A:C,3,FALSE)). I wanted to use a combo box so the user to add data to the table. When I made the combo box and used the drop list I was unable to populate the other cell using the formula I had. Can this be done Thanks for your help. Larry |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup with combo box
If you mean you wanted the user to be able to modify the Table range by
adding items to the data validation dropdown (combo box) the answer is well, maybe, depending on what you really want. The Contexture website shows many modifications of this topic area. If you are trying to use the value returned by the combo box to feed a VLOOKUP formula, that can be done. It depends on what you mean by combo box, if you are using the Data Validation command you can refernce the cell where it is from the VLOOKUP formula. For example if VLOOKUP(A1,Table,3,False) A1 could display the data validation list. If you are using a Form control or Control Toolbox combo box then you will can capture the number of the item it returns and then look up that. To do this you can link the combo box to any cell and then have VLOOKUP use that cell to do the lookup. You link by right-clicking the combo box and choosing Format Control, Control tab, Cell Link for a Form control. For a Control Toolbox you can select it on the toolbar click Properties, and set the Linked Cell property. -- Thanks, Shane Devenshire "Larry" wrote: I have a spread sheet were I was using a drop down list and was using data validation and vlookup to populate data in other cells. =IF(D6="","",VLOOKUP(D6,tablet!A:C,3,FALSE)). I wanted to use a combo box so the user to add data to the table. When I made the combo box and used the drop list I was unable to populate the other cell using the formula I had. Can this be done Thanks for your help. Larry |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup with combo box
My table is in another worksheet in my work book. When I use link range the
data will come. in but the vlookup wil not work. Can I do it this way. "ShaneDevenshire" wrote: If you mean you wanted the user to be able to modify the Table range by adding items to the data validation dropdown (combo box) the answer is well, maybe, depending on what you really want. The Contexture website shows many modifications of this topic area. If you are trying to use the value returned by the combo box to feed a VLOOKUP formula, that can be done. It depends on what you mean by combo box, if you are using the Data Validation command you can refernce the cell where it is from the VLOOKUP formula. For example if VLOOKUP(A1,Table,3,False) A1 could display the data validation list. If you are using a Form control or Control Toolbox combo box then you will can capture the number of the item it returns and then look up that. To do this you can link the combo box to any cell and then have VLOOKUP use that cell to do the lookup. You link by right-clicking the combo box and choosing Format Control, Control tab, Cell Link for a Form control. For a Control Toolbox you can select it on the toolbar click Properties, and set the Linked Cell property. -- Thanks, Shane Devenshire "Larry" wrote: I have a spread sheet were I was using a drop down list and was using data validation and vlookup to populate data in other cells. =IF(D6="","",VLOOKUP(D6,tablet!A:C,3,FALSE)). I wanted to use a combo box so the user to add data to the table. When I made the combo box and used the drop list I was unable to populate the other cell using the formula I had. Can this be done Thanks for your help. Larry |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup with combo box
Yes
"John C" wrote: Did you link the combobox to a cell? -- ** John C ** "Larry" wrote: I have a spread sheet were I was using a drop down list and was using data validation and vlookup to populate data in other cells. =IF(D6="","",VLOOKUP(D6,tablet!A:C,3,FALSE)). I wanted to use a combo box so the user to add data to the table. When I made the combo box and used the drop list I was unable to populate the other cell using the formula I had. Can this be done Thanks for your help. Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup,Index,or Combo of something else | Excel Discussion (Misc queries) | |||
Combo Box and VLOOKUP | Excel Discussion (Misc queries) | |||
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) |