Query/search question

I work in an organisation where acronyms and TLAs (three letter abbreviations) are commonplace and frequently used without consideration that not everyone is aware of the full meaning.

To ease the pain on myself and others, I would like to be able to create an excel spreadsheet that can offer the answer if an acronym is queried.

What i'd like to do is have the ability to query/search a list which contains acronyms in one column and the meaning in another by simply inputting the acronym into a 'search box'. To keep things tidy, I would probably look to have the search box on Sheet 1 and the data protected on sheet 2 to ensure the integrity of the data.

There may be some acronyms which (helpfully!) have more than one meaning. Is it possible to display more than one answer?

I've experimented with a few options but have now bottomed out my (average) excel knowledge and need some help.

John

Something like the attached, maybe.

Haseeb, Andrew,

Thanks. As a first time poster, the speed and utility of the replies is really helpful.

Andrew - Perfect. I will ensure that both your ETA definitions are included in my final solution!

Thanks.