Excel question - meeting multiple conditions to return data

For general computer discussion & help, come here

Moderators: Bakhtosh, EvilHomer3k

Post Reply
User avatar
stessier
Posts: 29816
Joined: Tue Dec 21, 2004 12:30 pm
Location: SC

Excel question - meeting multiple conditions to return data

Post by stessier »

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?
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
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
User avatar
stessier
Posts: 29816
Joined: Tue Dec 21, 2004 12:30 pm
Location: SC

Re: Excel question - meeting multiple conditions to return d

Post by stessier »

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
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
User avatar
coopasonic
Posts: 20966
Joined: Fri Mar 04, 2005 11:43 pm
Location: Dallas-ish

Re: Excel question - meeting multiple conditions to return d

Post by coopasonic »

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/
-Coop
Black Lives Matter
User avatar
stessier
Posts: 29816
Joined: Tue Dec 21, 2004 12:30 pm
Location: SC

Re: Excel question - meeting multiple conditions to return d

Post by stessier »

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
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
Post Reply