Posted to microsoft.public.excel.worksheet.functions
|
|
Muliple lookup in one cell
My is much neater than Dave.
"Roger Govier" wrote:
Much neater, Dave!!!
--
Regards
Roger Govier
"Dave Peterson" wrote in message
...
Or just:
=ISNUMBER(FIND("aaaa",A2)*FIND("2222",A2))
To the OP:
=Find() is case sensitive
=Search() is not case sensitive
Roger Govier wrote:
Hi Tim
One way
=IF(ISNUMBER(FIND("aaaa",A2))*ISNUMBER(FIND("2222" ,A2)),TRUE,FALSE)
copy down
--
Regards
Roger Govier
"TimD" wrote in message
...
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.
--
Dave Peterson
|