Find and Return

[kreffell]

Is it possible to find a number in col.A which is also found in col.C

Then in colB show the corresponding code shown in col.D

http://www.cadwax.com/excel.jpg

Many thanks
Keith

 

[Mike H]

Maybe this in column B and drag down

=IF(ISERROR(FIND(A2,C2,1)),"",D2)

Mike