Index / Match - match 3 input values and return the results from the index
I would like the user to input 3 values and return the result from the array. I have tried using index/match but I can't get it to work.
Index / Match - match 3 input values and return the results from the index
I would like the user to input 3 values and return the result from the array. I have tried using index/match but I can't get it to work.
May I ask why?
You might want to make it so there are inter-related dropdown boxes instead, or something along those lines.
It seems a little silly to me that if you know all three values, you simply don't use the filter feature of excel. Try highlighting your headers, and pressing CTRL+SHIFT+L, then click the drop down arrows and enter your data into the search box. It will filter everything that is not those values.
You can make inter-related drop down arrows like I mentioned, but that is quite complicated, I can probably try walking you through the process (or do it myself) if that sounds like something you'd be interested in.
You need to at least have data validation so they cannot enter values not in your lists. I require more information on what your goal is with this sheet to suggest the best route though.
Also, why is the thread marked as solved?
Try this array formula**:
=INDEX(D9:D56,MATCH(1,(A9:A56=B1)*(B9:B56=B2)*(C9:C56=B3),0))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks