Hi.

I have two worksheets, and each of the worksheets have 5 of the same columns. I want to take the 5 values (in the 5 different columns) and then check for a match in the other worksheet, and if there is a match, then return a value from a 6th column in the 2nd worksheet.

How would you do it?

THanks