Forum Discussion

porridge's avatar
porridge
Copper Contributor
Aug 04, 2022

CREATING SEARCH BOX

Hi, newbie here. I want to create a search box in this excel sheet. The function used is LET so it won't work on the online excel version, you have to download it. 

 

The search box should be linked in such a way that when I select the recipe that I am producing and the recipe that is next, the answer should be the ingredient for those 2 corresponding recipes. I don't know how to use macros or VBA so even after watching so many videos I wasn't able to make a search bar for this transpose table. I hope someone can guide me to create the search box. 

Thank you for your time and help 🙂

 

 

 

 https://docs.google.com/spreadsheets/d/1roHpCDScuk6tIy-af2DI53vxGa3tDGM8/edit?usp=sharing&ouid=115161584172678082193&rtpof=true&sd=true 

Formulas and Functions
Macros and VBA

1 Reply

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Aug 06, 2022

    porridge 

    In my Example the Search Cells are C1 and D1.

    =INDEX(D6:AP44,MATCH(C1,C6:C44,0),MATCH(D1,D5:AP5,0))

     See your attached fille in GoogleDrive.

Resources