Thread: Muliple lookup in one cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TimD TimD is offline
external usenet poster
  
Posts: 10
Default Muliple lookup in one cell
My data sample:

aaaa-*5#8-2222.zip
bbbb-0987-2345.dat
bbbb-*458-2222.xls

I want to return the cell that contains aaaa and 2222.


Reply With QuoteReply With Quote