=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.