These worked Great!
Thank you very much!!
Dan



"Dan B" wrote in message
...
Need some help with correct syntax...
I have 3 columns of data to compare. In the 2nd and 3rd columns, I want
to
look for matching numbers. Where a match is found, I want to check for a
1
in the 1st column. If all that matches, I want to copy the matching
number
in the 3rd column to a blank 4th column.

Basically, If B2 = any number in C2 thru C50, and A2=1 then copy B2 to D2.

I hope that makes sense.

Thanks