It was just a quick idea not really tested, it's hard if you have 100
different words

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"ExcelQuestion"
wrote in message
news:ExcelQuestion.2791tn_1146689704.2842@excelfor um-nospam.com...

One more thing. I noticed that the wildcard search is a bit open ended.
Within $A$1:$A$7, i tested it with A1 Development Cost, then A2
Development, then A3 Develop. In G1, I entered Develop and it picked
up the first "Develop"ment Cost instead of the "Develop" in A3.



ExcelQuestion Wrote:
Hi Peo,
This formula is good. You've added the wildcard for the match. Are
there ways other than an array formula because i'm sure other users
will not know the ctrl+shift+enter keystrokes?

I'm importing data consisting of about 100 rows into another tab. This
formula will point to it. So data validation list would not be
practical for this workbook.

Any ideas for a wildcard search without an array formula?

Thanks for everything so far.

Ricky


--
ExcelQuestion
------------------------------------------------------------------------
ExcelQuestion's Profile:
http://www.excelforum.com/member.php...o&userid=34059
View this thread: http://www.excelforum.com/showthread...hreadid=538567