Placing 1 of 24 outcomes based on drop-downs with three options

[TrickyGY66]

Hi All
I am a newbie to excel and f anyone could help me please , i would be very grateful.
I have a worksheet with 3 conditions picked from a dropdown box and want to place 1 of 24 outcomes that are possible.

Thanks in advance
TrickyGY

[JohnTopley]

More explantion is required !!!

A sample worksheet with expected results will certainly help.

[TrickyGY66]

i did upload a worksheet and thought it would attach automatically, just working out how to attach a worksheet

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I have done it for you today..)

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[TrickyGY66]

Thank You for the help

[AliGW]

OK - where is the drop-down? What are the possible outcomes? We still need a lot more information.

[TrickyGY66]

Dropdown 1 for A4 is on Tab 2 at A1 ( substance category with 5 possible conditions.
Dropdown 2 for C4 is on Tab 3 at A1 ( Line size with 3 possible conditions
Dropdown 3 for F4 is on Tab 3 at C1 ( intrusive work with 2 possible conditions

Sorry for being a pain

[TrickyGY66]

Sorry for the lack of info, this is what im trying to do,
IF A4 = 1 & C4 = <50 & F4 = YES then A7 will be V - DBB from C4 on sheet 4.

The dropdowns for condition are on the selection tool tab A4 C4 F4 and the outcomes are on tab 4.

Thanks
Tricky

[AliGW]

There is nothing on sheet 4 ...

You're making this very tricky, Tricky.

[TrickyGY66]

Sheet 4 isolations standards has the 24 possible outcomes.

[AliGW]

Nope!!!

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

Sheet: Isolation Standard Formulas

[AliGW]

I can't work anything out based on the workbook you have given us - I think there is lookup data missing. Here's what you've given us:

Excel 2016 (Windows) 32 bit

	A	B
1	Column1	Column2
2	Fluid Catergory
3	1
4	2
5	3
6	4
7	5

Sheet: Substance Categories

Excel 2016 (Windows) 32 bit

	A	B	C
1	Column1		YES
2	10		NO
3	20
4	30
5	40
6	50
7	60
8	70
9	80
10	90
11	100
12	110
13	120
14	130
15	140
16	150
17	160
18	170
19	180
20	190
21	200
22	210
23	220
24	230
25	240
26	250
27	260
28	270
29	280
30	290
31	300

Sheet: Line Size

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

Sheet: Isolation Standard Formulas

Explain using the above how I would work out what the 24 possible outcomes should be.

[TrickyGY66]

sorry, my sheet 4 is corrupted for some reason, i will rework it.

Thanks

[AliGW]

OK - when you've done that, post a new copy to your next post and then we can take it from there.

[TrickyGY66]

Hopefully the worksheet has all the info on now.

[AliGW]

Hopefully ... but you'll need to attach it here. Follow the instructions at the top again - you've obviously missed a step or clicking the upload button.

EDIT: It's appeared now.

[TrickyGY66]

just edited with attachment

[AliGW]

What does this mean?

50<200

Do you mean between 50 and 200?

[TrickyGY66]

yes between 50 and 200

[AliGW]

First I turned your lookup table into something easier to use using PowerQuery:

Excel 2016 (Windows) 32 bit

	J	K	L	M
4	Merged	<50	50<200	>200
5	1NO	V - DBB	V - DBB	V - DBB
6	1YES	N/A	N/A	N/A
7	2NO	V - SBB	V - SBB	V - SBB
8	2YES	I - DBB	I - DBB	I - DBB
9	3NO	V - SBB	V - SBB	V - SBB
10	3YES	I - SBB	I - SBB	I - SBB
11	5NO	V - SBB	V - SBB	V - SBB
12	5YES	I - SVI	I - SVI	I - SVI

Sheet: Isolation Standards

Then I used this formula:

=INDEX('Isolation Standards'!$K$5:$M$12,MATCH('Selection Tool'!A4&'Selection Tool'!F4,'Isolation Standards'!$J$5:$J$12,0),MATCH('Selection Tool'!C4,'Isolation Standards'!$K$4:$M$4,0))

[TrickyGY66]

Thank You very much Ali,
So whatever 3 conditions are selected now it will insert the outcome into the minimum isolation standard box?

[AliGW]

Try it ...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

By the way, I would remove 4 as an option from the first drop-down and the header wording from the YES/NO drop-down list, as neither is required.