search for specific data in two columns and if it matches returns an ID number

Hi,

I have created user form that searchs for specific data in two columns and if it matches returns the ID number.

I dont know why but the code it's not working. I've done it before using two comboboxes and it worked great but now, i can't seem to get it right.

The file is in attach.

Can anyone help?

Thanks

Hello ncaravela,

You had 2 problems. First you were searching in column 15 when it should have been column 14. Second, the values in a ComboBox list are always string data types. The values on the worksheet are numbers in column 15. This will throw a "Type Mismatch" error. The solution is to return the cell's value as a string using the Text property. The code below has the changes made.

Please Login or Register  to view this content.