LOOKUP function troubles...please help!

HTSNY_JACK

New Member
Joined
Nov 19, 2013
Messages
4
HI - I am trying to work out using the proper function(s) to achieve my desired result, but I am severely stumped.

I need a spreadsheet that allows a user to make 3 decisions and have the result of those 3 decisions returned so that a formula can reference that amount to help me determine pricing. I will try to illustrate it and hopefully there is a genius out there that can help me.

There are 2 divisions, "1" and "2", each with different colors associated with them (3 colors in division 1, 2 colors in division 2), and each of these colors has 2 prices associated with it (an "H" price and an "RP" price) -- the first drop-down menu will contain a choice between "1" and "2", if the user selects division "1", then the options "blue", "green", and "red" must be visible for selection in the next cell. If they select division "2", then the options "black" and "blue" must be visible for selection in the next cell. Once the division is selected, then the color is selected, then the "H" or "RP" is selected, the corresponding amount for either the H or RP will be returned.

DIVISION COLOR H/RP PRICE
1BLUEH$1
RP$2
GREENH$3
RP$4
REDH$5
RP$6
2BLACKH$7
RP$8
BLUEH$9
RP$10

<tbody>
</tbody>


Is something like this even possible??? i absolutely appreciate any help that anyone can offer. I am trying to run a very small business and I really could use a spreadsheet that works this way to help me keep things more organized. Thank you in advance!

-Jack
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,098,991
Messages
5,465,863
Members
406,451
Latest member
KARANDREA

This Week's Hot Topics

Top