View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Welly Welly is offline
external usenet poster
 
Posts: 4
Default 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.