I have a spreadsheet and am trying not to use macros or visual basic.
On Sheet A, I have 3 drop down boxes. Based on the choices made in those 3 boxes, I want to return a row of data from Sheet B into a set location on Sheet A.
Is this possible?
Excel question - meeting multiple conditions to return data
Moderators: Bakhtosh, EvilHomer3k
- stessier
- Posts: 29840
- Joined: Tue Dec 21, 2004 12:30 pm
- Location: SC
Excel question - meeting multiple conditions to return data
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Global Steam Wishmaslist Tracking
Running__ | __2014: 1300.55 miles__ | __2015: 2036.13 miles__ | __2016: 1012.75 miles__ | __2017: 1105.82 miles__ | __2018: 1318.91 miles | __2019: 2000.00 miles |
- stessier
- Posts: 29840
- Joined: Tue Dec 21, 2004 12:30 pm
- Location: SC
Re: Excel question - meeting multiple conditions to return d
Hmmm, Index Matching looks like it might be the key.
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Global Steam Wishmaslist Tracking
Running__ | __2014: 1300.55 miles__ | __2015: 2036.13 miles__ | __2016: 1012.75 miles__ | __2017: 1105.82 miles__ | __2018: 1318.91 miles | __2019: 2000.00 miles |
- coopasonic
- Posts: 20993
- Joined: Fri Mar 04, 2005 11:43 pm
- Location: Dallas-ish
Re: Excel question - meeting multiple conditions to return d
I don't do anything with dropdowns, so I am not sure how that would wire in, but take a look at the INDEX function and get creative.
This might help you along:
http://www.exceltactics.com/vlookup-mul ... x-match/3/
This might help you along:
http://www.exceltactics.com/vlookup-mul ... x-match/3/
-Coop
Black Lives Matter
Black Lives Matter
- stessier
- Posts: 29840
- Joined: Tue Dec 21, 2004 12:30 pm
- Location: SC
Re: Excel question - meeting multiple conditions to return d
Yep, that did the trick Coop - thanks! I also found this link (including for when I have this problem again).
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Global Steam Wishmaslist Tracking
Running__ | __2014: 1300.55 miles__ | __2015: 2036.13 miles__ | __2016: 1012.75 miles__ | __2017: 1105.82 miles__ | __2018: 1318.91 miles | __2019: 2000.00 miles |