My sheet1 contains model and serial numbers of equipment in my customer base. There are some 30,000 combinations. My sheet 2 contains model numbers and a code for each one. There are only about 600 different model numbers.

I want to match the model numbers from the two sheets and report the code for the model on the sheet with the serial numbers.

I've tried if sheet1.colA=sheet2.colB then sheet2.colC else "z", but I get more Z's than codes.

Hope this makes it more clear for you.

Thanks for your help.

Margaret