VLookUp Run Time Error

[dinosaur1993]

Does anyone have any idea what I am doing wrong?

Please Login or Register  to view this content.

cheers!

[Debraj Roy]

* Column parameter missing.. 3rd parameter

[TMS]

Where you have " ... , , False" you need a number between the commas ... the relative column within the search area for the information to be returned.


Regards, TMS

[dinosaur1993]

ah thanks!

sorry Ive tried that, but it still comes up as a run time error for Vlookup function

[TMS]

You have two independent answers both advising that the third parameter is missing ... which it is. It needs to be a number between 1 and 10 although 1 would only return the search key.

With the information provided, there's not a lot else to suggest. There's no error trapping so it could be that the item being searched for is not found.

Regards, TMS

[Debraj Roy]

try this..

Please Login or Register  to view this content.

[Andy Pope]

Fully qualify the lookup table.

Please Login or Register  to view this content.

Also if the lookup column is numeric you will need to coerc you combobox value

[dinosaur1993]

what do you mean by 'coerc'? thanks!

[Andy Pope]

spelling mistake, coerce.

Please Login or Register  to view this content.

convert the combobox value, which may look numeric, into an actual number.

But as suggested, rather than make us all guess at what you have setup why not post example data file to illustrate your problem.

[TMS]

@Andy: I'm guessing from the sheet name that it's a car registration so that's probably going to be text looking up text.