Thread: VLookup
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L.Mathe L.Mathe is offline
external usenet poster
 
Posts: 24
Default 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
---