Excel VBA-vlookup combo box problem

[Saika]

Hi can someone please help me.

I have created a worksheet in which i have Vlookup formulaes reading o
another worksheet which has combobox with drop down lists and linke
cells. Everything works apart from the comboboxes whose populate
linked cells are not being recognised by the v-lookup function. Th
Vlookup is as follows:

vlookup(e18,'policy'!c5:098,7,false)

The data within the combo box is a mixture of text and numerical e.
L32H11-1, EM2H11-1

I have put a double minus sign in front of e18 and it returns
#value!

Can someone please help me.

thanking you in anticipation

Saik

 

[Bob Phillips]

What is the range c5:098 supposed to be? This should be a range like C5:C98.

The -- wo n't help you in this problem.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Saika]

C5:O98 is the range of data within the policy worksheet

 

[Bob Phillips]

Saika,

Assuming that E18 is the cell linked to the combo to capture the selected
value, and that it is O98 (not 098 as your OP). the VLOOKUP should work.
What do you get or not?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)