Hi Guys,
Sorry if this is simple, but i'd like a risk assessment matrix to fill automatically based on the combination on two drop down options, so if "L1" and "C2" are entered into the sheet, the result would be "High", but if it was "L1" and "C4" the result in the Column E would be "Extreme". Is there a quick way to do this? I'd like it to be automatic for staff to fill out quickly
I've messed around with indexing and IF AND functions but haven't found anything that works.
Table 1 is in sheet1: Assum table is in A1:F6, with L1-L5 in A3:A6, C1-C5 in B2:F2
Cell E2:
Please Login or Register to view this content.
Quang PT
Thank you so much! I really appreciate it
Hi,
This worked for me in the one cell I started with but when I attempted to drag this formula down on my own risk register the array's changed to move across one additional cell. So within your own formula below where I want the bold parts to change accordingly the italic parts would need to remain fixed but this is not the case for me....
=INDEX(sheet1!B3:F6,MATCH([C2,sheet1!A3:A6,0),MATCH(D2,sheet1!B2:F2,0))
My formula is turning into this:
INDEX(sheet1!B4:F7,MATCH(C3,sheet1!A4:A7,0),MATCH(D3,sheet1!B3:F3,0))
The lookup value is changing to what I want it to but the array change results in the formula returning an N/A.
Anchor the ranges:
=INDEX(sheet1!$B$3:$F$6,MATCH(C2,sheet1!$A$3:$A6,0),MATCH(D2,sheet1!$B$2:$F$2,0))
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You're a star Ali! Thank you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Unfortunately I am not the OP so I don't believe that option is available to me
Ooh, naughty! You should not hijack other people's threads! For future reference, see below.
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Haha my bad, I discovered this website all of 20 minutes ago in my desperation for help with this very issue
You nearly made it, but I let Santa know - you're on the naughty list now!!!
Hahaha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks