forgot to mention an autofilter could be an option.

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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