Keyword Search - not by VLOOKUP

[Palo-admin]

Keyword Search - not by VLOOKUP

Devesh, January 29, 2010

Friends
I am having some problem with keyword search. I have a workbook with 2 different worksheet.
Worksheet 1 is the headline page. Worksheet 2 is the page that has all the information in column B.

Worksheet 1
Column A Column B
Company Name Information


Worksheet 2

Column A Column B
Company Name Information
MSFT xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

EXXON xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Now I want to search for MSFT. So in Worksheet 1 (A2) I enter MSFT. Now,
I need to see in B2 of worksheet 1 the information if the keyword is found.
he keywords can be 'gains, upgrade, downgrade etc. '

So the formula should be searching for keyword for MSFT in worksheet 2
and display the result in worksheet 1 B2 if the keyword exist.

Look forward to the solution.
Thanks

Hi Devesh
If you do not want to use macros, you can use combination of OFFSET and MATCH function.

See example here: http://www.pc-prog.eu/phpBB3/images/xMyKB/Keyword_Search_Via_MATCH.xls

How to use parameter of both functions, see internal Excel help.

K_find_via_MATCH_1.GIF

K_find_via_MATCH_2.GIF

TIP: To pick company name from list, use can you Cell Validation.

K_find_via_MATCH_3.GIF

If you want to use as a list source data from other sheet, you must use named range.

K_find_via_MATCH_4.GIF

I hope, it helps to you.
Palo