Hi Ahmed

Thank you for your feedback. Am glad that this work for you

Appreciate that you click on the Yes button below in order that
others could find the answer to similar case like yours in the future
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"ahmed" wrote:

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))