sixsteps268
New Member
- Joined
- May 9, 2013
- Messages
- 15
Many many thanks in advance for what I've been told by other users, will be a big sucess in asking you experts for help! So needless to say I'm a first timer here on Mr. Excel.
What I need to do is return a value from a table based upon 3 variables. Variable 1 has 2 options, Variable 2 has 4 options, and Variable 3 has 9 options.
So my table has obviously 4 columns and I need to be able to return the value based upon the selection of variable 1, then by variable 2, and finally by variable 3. Does that make sense?
I've tried several things ranging from if and nested vlookups to a choose function and I can't seem to get it right.
Someone please help rescue me! This is for my boss and a big presentation!
Thanks!
What I need to do is return a value from a table based upon 3 variables. Variable 1 has 2 options, Variable 2 has 4 options, and Variable 3 has 9 options.
So my table has obviously 4 columns and I need to be able to return the value based upon the selection of variable 1, then by variable 2, and finally by variable 3. Does that make sense?
I've tried several things ranging from if and nested vlookups to a choose function and I can't seem to get it right.
Someone please help rescue me! This is for my boss and a big presentation!
Thanks!