Search Range for item in seperate range
Thanks, this seems to work, however I can't say I understand the
formula. I haven't seem the -- before, what does that do? So it looks
like transpose is creating an array, how is checking the array
different than simply checking a range such as L1:O1?
-Andrew
|