ExcelBanter - Find and Return

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find and Return (https://www.excelbanter.com/excel-discussion-misc-queries/161890-find-return.html)

kreffell

Find and Return

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[_3_]

Find and Return

Maybe this in column B and drag down

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

Mike

On 12 Oct, 14:20, "kreffell" <u38188@uwe wrote:
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

All times are GMT +1. The time now is 12:16 AM.