Keyword Search - not by VLOOKUP

Common problems – different language?
Let's talk in English.

Keyword Search - not by VLOOKUP

Poslaťod Palo-admin » 08.02.2010, 11:15

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
Nemáte oprávnenie prezerať súbory priložené v tomto príspevku.
Palo-admin
Administrátor stránky
 
Príspevky: 473
Registrovaný: 18.07.2008, 16:43
Udelené poďakovania: 6 krát
Prijaté poďakovania: 63 krát

Späť na Solving MS Office problems in English

Kto je on-line

Užívatelia prezerajúci fórum: Žiadny registrovaný užívateľ nie je prítomný a 1 hosť

cron