Forum Discussion

Lewis Brazier's avatar
Lewis Brazier
Copper Contributor
Nov 07, 2017

Search a table of data and return an answer

Hello, 

My spreadsheet if for work and because of this I cannot use the real sheet but what I have done is created a similar version, mostly the same just without the information on it. 

I have 2 sheets "Search" and "WI_EM's". On the search sheet I have a small table with a Search box and a Results box. So when I type something into the search box I want the answer in the results box. 

Sheet WI_EM's has all of the information on it. The information I will be searching for is in column B and the answer is is column A. 

Column B will have loads of text which will be a small desperation of something and column A will be a code which consists of both numbers and letters.

So if I am to type a search criteria on my search sheet in cell A2, I want that to search Sheet 2 column B find the match and then give me the corresponding answer from column A and input that into my search sheet cell B2.

 

I have attached a copy of my sheet and have inputted some random info. The Document title will be a small description on a device that my company use. The Revision I don't need to worry about searching but need it to stay on the sheet and the same for the date. 

 

The Document Title/Description will have small abbreviations for devices eg, Fb for Facebook, COD for Call of Duty. So as long as the person who is searching for something knows the code of a device there should never be multiple answers. 

 

So I was to type in "Flooring" into my search box (A2) I want the sheet to then put "CDI181_U4" in cell B2. 

 

I hope all of this makes sense. I have been messing around with a load of formulas and have been for several months now. I hope its just me not knowing what I am doing. As this will help me out, as we are just after a really quick search.

 

 

No RepliesBe the first to reply