Search Feature

**Shazz** · 11-17-2009, 08:26 AM

I am not sure if this can be done, I have a list in Excel that I would like to be able to search for words without having to use the CTRL F Feature.

Does anyone now if there is a formula where you can type a word in a cell and it will search the whole document.

Thanks for your help

Shazz

**rwgrietveld** · 11-17-2009, 08:44 AM

What we need to know is the word(s) your are looking for and
the range where the word(s) might be found.

**Palmetto** · 11-17-2009, 09:01 AM

You would need to use an input cell and VBA code to find the value.
As rwgrietveld suggested, a sample workbook would be helpful. However, here is the basic code and a sample workbook to get you started.

This will search for a value entered into cell D1 and will only look in column-A.

Please Login or Register  to view this content.

**broro183** · 11-17-2009, 09:08 AM

also...
What do you want as the result?
eg, the sheet/cell address of where the word is found,
or,
a value in an adjacent column to where the word is found,
or...

If you are open to using macros, Tushar's Findall code may be of interest: http://www.tushar-mehta.com/excel/tips/findall.html

hth
Rob