Thread: VLookup
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default VLookup
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
---

Reply With QuoteReply With Quote