Thread: Combining two ranges based on common a common value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ahmed[_3_] ahmed[_3_] is offline
external usenet poster
  
Posts: 3
Default Combining two ranges based on common a common value
This worked fine. Thank you for your time.

---
ahmed




Francis wrote:
try this in col 4, D2 and copy down

=IF(ISNA(VLOOKUP(A2,$H$2:$I$4,2,0)),"",VLOOKUP(A2, $H$2:$I$4,2,0))

Reply With QuoteReply With Quote