Hello Sir we want formula for extrat 2 words filter from a long words which is in Colum C
2 words (MP & MLC )
if above two words in any name then Show these words in Colum H
AGRAMLCOTHER
AGRAMPOTHER
AllahabadMPOTHER
AllahabadMLCOTHER
KanpurMLCOTHER
KanpurMPOTHER
Actually other words must add after MP or MLC
pls suggest me formula or function
Thanks
Hi Santosh,
use this
Formula:
Please Login or Register to view this content.
Click on * below if you find this helpful
Thanks,
A
amy sir thanks for reply
ur formula working but when we drag these formula to all database then forula sow MLC those record where no mp or mlc word exit... we want <blank> in that record..
Try in H1 and copy down.
=IFERROR(LOOKUP(2^15,SEARCH({"MLC","MP"};C1),{"MLC","MP"}),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fortis Sir Thank for reply but sir when we copy ur formula in H1 Cell then a msg diloge box display
"The formula you typed contains an error"
sir is it an arrey formula???
Perhaps you do something wrong. Take a look to the sample.
sir we look ur file in ur file forula define
=_xlfn.IFERROR(LOOKUP(2^15,SEARCH({"MLC","MP"},C1),{"MLC","MP"}),"")
=IF(ISERROR(LOOKUP(2^15,SEARCH({"MLC","MP"},C1),{"MLC","MP"})),"",LOOKUP(2^15,SEARCH({"MLC","MP"},C1),{"MLC","MP"}))
first formal not working _xlfn dont know what is this??
but 2nd formals working fine..
Thanks a lot sir
Santos.
Apologize. I didn't noticed that you use Excel 2003. So IFERROR does not work for Excel2003. That's why you got the error..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks