i have to find values based on 3 non-contiguous columns in another worksheet. i
can concatenate the string i'm looking for, but what's the best way to find that
string in 3 non-contiguous columns in another worksheet.

tried union as the range to search but couldn't get it to work.

just looking for ideas, no need to write any code.

thanks


--


Gary