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
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
Last edited by AliGW; 02-21-2021 at 02:41 AM.
More explantion is required !!!
A sample worksheet with expected results will certainly help.
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..)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i did upload a worksheet and thought it would attach automatically, just working out how to attach a worksheet
There are instructions at the top of the page explaining how to attach your sample workbook.
Thank You for the help
OK - where is the drop-down? What are the possible outcomes? We still need a lot more information.
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
Last edited by TrickyGY66; 02-21-2021 at 02:39 AM.
There is nothing on sheet 4 ...
You're making this very tricky, Tricky.
Sheet 4 isolations standards has the 24 possible outcomes.
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
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
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 1Column1 Column2 2Fluid Catergory 3 1 4 2 5 3 6 4 7 5
Sheet: Substance Categories
Excel 2016 (Windows) 32 bit
A B C 1Column1 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.
Last edited by AliGW; 02-21-2021 at 02:57 AM. Reason: Typo
sorry, my sheet 4 is corrupted for some reason, i will rework it.
Thanks
OK - when you've done that, post a new copy to your next post and then we can take it from there.
Hopefully the worksheet has all the info on now.
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.
just edited with attachment
What does this mean?
50<200
Do you mean between 50 and 200?
yes between 50 and 200
First I turned your lookup table into something easier to use using PowerQuery:
Excel 2016 (Windows) 32 bit
J K L M 4Merged <50 50<200 >200 51NO V - DBB V - DBB V - DBB 61YES N/A N/A N/A 72NO V - SBB V - SBB V - SBB 82YES I - DBB I - DBB I - DBB 93NO V - SBB V - SBB V - SBB 103YES I - SBB I - SBB I - SBB 115NO V - SBB V - SBB V - SBB 125YES 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))
Thank You very much Ali,
So whatever 3 conditions are selected now it will insert the outcome into the minimum isolation standard box?
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.
Last edited by AliGW; 02-21-2021 at 03:52 AM. Reason: Typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks