Find and Return

kreffell · Oct 12, 2007

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 · Oct 12, 2007

Maybe this in column B and drag down

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

Mike

Find and Return

kreffell

Mike H