ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Search Box (https://www.excelbanter.com/excel-discussion-misc-queries/170553-search-box.html)

Tmms

Search Box
 
I am making a small dictionary in Excel 2003 and will like to know if someone
knows how I can insert a search box to find a word of the dictionary. Thnaks
a lot!!

Mike H

Search Box
 
I'm not sure what you mean by 'Find' do you mean that or do you mean go to.
Here' one way.

With your words in column A and and their definitions in column B and the
word you are looking for in C1 try this formula:-

=VLOOKUP(C1,A:B,2,FALSE)

Mike

"Tmms" wrote:

I am making a small dictionary in Excel 2003 and will like to know if someone
knows how I can insert a search box to find a word of the dictionary. Thnaks
a lot!!



All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com