Risk Assessment

roblouk

New Member
Joined
Apr 13, 2023
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I have the below risk assessment workbook, the first sheet has questions and dropdown lists of answers for each question then a column to display the risk score for each answer. The second sheet is the answers for each question to go in the dropdown lists and the third sheet is the risk scores assigned to each answer. This list of questions and answers extends considerably so I am looking for a formula I can use to pull the risk score into column E based on the answers to the question.

I am not particularly fussy about the layout or formatting if there is a more sensible way to do this but I am hoping there is an easy way I can pull the information across. The risk scoring, questions and responses need to be kept out of the formula so they can be changed if required.

Hopefully this makes sense and thank you for the help!

Falls Care Quality Assessment (FCQA).xlsx
ABCDE
1 NumberQuestion TextQuestion NotesResponsesRisk Score
21What did the patient say happened (where appropriate or possible to ascertain)?Please give a summary from the patient’s perspective.Free Text
32What did staff say happened?Please include any information you believe may have contributed to the fall including: Where members of staff were at the time of the fall, ward acuity, anything different on this shift, any changes in the patient.Free Text
43Was the fall witnessed?The fall was witnessed if another person was present when the patient fell and is able to give a reliable account of what they observed immediately before, at the point of the fall and immediately afterwards.
54Was the patient on their own at the time of the fall?If the patient was in a location with another patient or visitor but no staff or family/friends were present, answer that the patient was on their own. If a member of staff or family member was in the same room or bay but did not have the patient in their sight line (i.e. the patient was behind a curtain or door), consider the patient to be on their own.
65What was the patient doing at the time of the fall?If the patient was in the process of getting up or sitting down from the bed / chair / commode, choose “transferring between the bed / chair / commode”.
Questions
Cells with Data Validation
CellAllowCriteria
D4List=Responses!$C$2:$C$3
D5List=Responses!$D$2:$D$4
D6List=Responses!$E$2:$E$9

Falls Care Quality Assessment (FCQA).xlsx
ABCDE
112345
2Free textFree textYesThe patient was on their ownLying/sitting in the bed
3NoThe patient was with a member of staffSitting in a chair
4The patient was with a family member or friendUsing a commode
5Transferring between the bed/chair/commode
6Walking on the ward
7Using the toilet/bathroom
8Not on the ward at the time of the fall
9Not known as the fall was unwitnessed
Responses

Falls Care Quality Assessment (FCQA).xlsx
ABC
1QuestionAnswersRisk Score
2What did the patient say happened (where appropriate or possible to ascertain)?1
3Free textN/A
4What did staff say happened?2
5Free textN/A
6Was the fall witnessed?3
7Yes0
8No0
9Was the patient on their own at the time of the fall?4
10The patient was on their own0
11The patient was with a member of staff1
12The patient was with a family member or friend1
13What was the patient doing at the time of the fall?5
14Lying/sitting in the bed1
15Sitting in a chair1
16Using a commode1
17Transferring between the bed/chair/commode0
18Walking on the ward0
19Using the toilet/bathroom0
20Not on the ward at the time of the fall0
21Not known as the fall was unwitnessed0
Risk Scoring
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Hi, try this formula for E2 cell (Range: E2:E6)
=IF(A2<3,"N/A",VLOOKUP(D2,'Risk Scoring'!B:C,2,0))
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,193
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top