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