Thread: Find and Return
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
  
Posts: 39
Default 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


Reply With QuoteReply With Quote