| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box / VLOOKUP
Is it possible to link a VLOOKUP to the data in a combo box?
I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
Link the results of the combobox to a cell and use that cell in the vlookup.
-- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
Hi Tom,
My linked cell just produces a number of where the value of the combo box is in the table eg if i select Austria in the combo box the link cell displays 1 as Austria is the first country in the list. "Tom Ogilvy" wrote: Link the results of the combobox to a cell and use that cell in the vlookup. -- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
Solved it,
Thank you "Welly" wrote: Hi Tom, My linked cell just produces a number of where the value of the combo box is in the table eg if i select Austria in the combo box the link cell displays 1 as Austria is the first country in the list. "Tom Ogilvy" wrote: Link the results of the combobox to a cell and use that cell in the vlookup. -- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
=offset(cell in topleft of data,cell with index number from combo, Column
Offset,1,1) -- Regards, Tom Ogilvy "Welly" wrote: Solved it, Thank you "Welly" wrote: Hi Tom, My linked cell just produces a number of where the value of the combo box is in the table eg if i select Austria in the combo box the link cell displays 1 as Austria is the first country in the list. "Tom Ogilvy" wrote: Link the results of the combobox to a cell and use that cell in the vlookup. -- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
How did you solve this? I am having the same problem with a number coming up.
"Welly" wrote: Solved it, Thank you "Welly" wrote: Hi Tom, My linked cell just produces a number of where the value of the combo box is in the table eg if i select Austria in the combo box the link cell displays 1 as Austria is the first country in the list. "Tom Ogilvy" wrote: Link the results of the combobox to a cell and use that cell in the vlookup. -- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo Box / VLOOKUP
You can use a combo box from the control toolbox and it will return the
selection to the linked cell while a combo box from the forms toolbar returns an index number. -- Biff Microsoft Excel MVP "Novice_Excellerator" wrote in message ... How did you solve this? I am having the same problem with a number coming up. "Welly" wrote: Solved it, Thank you "Welly" wrote: Hi Tom, My linked cell just produces a number of where the value of the combo box is in the table eg if i select Austria in the combo box the link cell displays 1 as Austria is the first country in the list. "Tom Ogilvy" wrote: Link the results of the combobox to a cell and use that cell in the vlookup. -- Regards, Tom Ogilvy "Welly" wrote: Is it possible to link a VLOOKUP to the data in a combo box? I am trying to create a report where a country is selected from the combo box. The VLOOKUP picks up this value and the country is then displayed in a number of cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Box - How to Use Output in Vlookup | Excel Discussion (Misc queries) | |||
| using vlookup with combo box | Excel Worksheet Functions | |||
| Combo Box and VLOOKUP | Excel Discussion (Misc queries) | |||
| vlookup from a combo box? | Excel Discussion (Misc queries) | |||
| Vlookup from Combo Box | Excel Discussion (Misc queries) | |||
Linear Mode
