Creating Search box

Occasional Contributor

Hello my fellow Excel Wizards,

I would like to know how to make a search box on excel file. I have no prior knowledge of macros or vba.

 

 

 This is the table and in the corner I want to create a search box which will show me the text present in the white cell. This is a transpose table and the vertical column is recipe to be produced and the horizontal is for the next recipe to be produced. so when i create the search box, the answer should show me the exact text present in the table. the table is linked to table 3 to get the data.
Thank you for your help and time.

 

 

2 Replies
Search in which cells?
the data which is in the noncoloured cells. example. if I am making recipe 1 and then producing recipe 2 so as per the image my answer should be "Lait". Let me know if you want to take a look at the file and understand it clearly. sry for my English it's not that good