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 linke...
Formulas and Functions
Macros and VBA
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