VLookup
You guys are GREAT! - This works.
Thank you!!
--
Linda
"Max" wrote:
Former was overkill, sorry. This suffices in F2, copied down,
but I think Bob has beaten me to it:
=IF(AND(ISNUMBER(MATCH(C2,D:D,0)),ISNUMBER(MATCH(C 2,E:E,0))),C2,"")
--
Max
Singapore
---
|