Excel keyword finder - using an old thread for a new problem

[googleplex]

Hi

I am similarly interested in using the logic in this thread http://www.excelforum.com/excel-prog...uplicates.html

Basically I want to be able to type in a keyword and then bring up a number of matching results along with their associated code.

Using the spreadsheet in the above thread, I tried to add an extra entry as a test, as my database contains roughly ~1500 entries, but excel doesn't seem to like me adding 1 more entry and adjusting the dimensions of the code?

Is there something I'm missing?

Thanks in advance

[JBeaucaire]

Those are ARRAY formulas. When you make a change, press CTRL-SHIFT-ENTER to confirm the changes and activate the array.

THEN you can copy the cells down.

[googleplex]

D'oh!

Thanks very much