VLookup with Multiple Values

Manny74

Board Regular
Joined
May 6, 2016
Messages
124
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello, this is a small sample of my data...
The large amount of data will vary from month to month with many more departments...
I like using VLOOKUP.....It's worked for individual departments....
I was able to use VLOOKUP for 8NT....For example, =VLOOKUP(A10,A2:C7,3,FALSE)

But I how would I use VLOOKUP to get, let's say the Numerator for question, Is Dispenser filled for 10NT?
I never used multiple values (Question & Department) in VLOOKUP....

Hygiene - Vlookup.JPG
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
I suggest to update your profile about Excel version & OS and use XL2BB to post representative source example and expected result (not a picture)
 
Upvote 0
Hello, this is a small sample of my data...
The large amount of data will vary from month to month with many more departments...
I like using VLOOKUP.....It's worked for individual departments....
I was able to use VLOOKUP for 8NT....For example, =VLOOKUP(A10,A2:C7,3,FALSE)

But I how would I use VLOOKUP to get, let's say the Numerator for question, Is Dispenser filled for 10NT?
I never used multiple values (Question & Department) in VLOOKUP....

View attachment 27801
I suggest to update your profile about Excel version & OS and use XL2BB to post representative source example and expected result (not a picture)
I would like to, but I dont understand how it works and how to download it? Are you unable to view my screen shot?
 
Upvote 0
sure, post a link to the shared excel file with representative example of source data and expected result, use onedrive, googledrive or any similar
don't forget to update your profile about excel version & OS
 
Upvote 0
sure, post a link to the shared excel file with representative example of source data and expected result, use onedrive, googledrive or any similar
don't forget to update your profile about excel version & OS
Ok you lost me....I dont know how to do any of this....
 
Upvote 0
1. on top right corner of this page you can see your Manny74 name, click this and choose Account details then check your excel version and OS, don't forget to scroll down and click save (important!)
2. post your question how to use XL2BB here XL2BB - Excel Range to BBCode , maybe author will explain this better
 
Upvote 0
maybe use a Pivot Table
QuestionObservationNumDenComp%DepartmentDepartment10NT
Is Dispenserfilled?Hygiene By Dept331008NT
Is Dispenserfilled?Hygiene By Dept237510NTQuestionNumDenComp%
Is PaperTowel Dispenserfilled?Hygiene By Dept111008NTDid employee complete hand hygiene?030
Is PaperTowel Dispenserfilled?Hygiene By Dept4410010NTIs Dispenserfilled?2375
Did employee complete hand hygiene?Hygiene By Dept34758NTIs PaperTowel Dispenserfilled?44100

ptf.png

much easier than formula :)
 
Last edited:
Upvote 0
1. on top right corner of this page you can see your Manny74 name, click this and choose Account details then check your excel version and OS, don't forget to scroll down and click save (important!)
2. post your question how to use XL2BB here XL2BB - Excel Range to BBCode , maybe author will explain this better
So I tried a pivot table....
Placed Department in Filters
Values in Column
Questions in Rows
Count of Den, Count of Num and Count of Overall Comp % in Values....I dont need the Count of Overall Comp % in Values, I need the %, the actual value.....
Right now I get this?


Department4NT
Row LabelsCount of NumCount of DenMin of Comp %
Did ANESTHESIOLOGIST complete hand hygiene?
1​
1​
0%​
Did CASE MANAGER/SOCIAL WORKER complete hand hygiene?
1​
1​
0%​
Did DIETARY/TRAY PASSER complete hand hygiene?
1​
1​
6670%​
Did EVS complete hand hygiene?
1​
1​
0%​
Did MEDICAL STUDENT complete hand hygiene?
1​
1​
0%​
Did NURSE complete hand hygiene?
1​
1​
0%​
Did NURSING SUPPORT/PCA complete hand hygiene?
1​
1​
7500%​
Did OTHER staff complete hand hygiene?
1​
1​
0%​
Did PA/ARNP complete hand hygiene?
1​
1​
0%​
Did PHYSICIAN complete hand hygiene?
1​
1​
0%​
Did PT/OT complete hand hygiene?
1​
1​
0%​
Did RESIDENT complete hand hygiene?
1​
1​
10000%​
Did RESPIRATORY THERAPIST complete hand hygiene?
1​
1​
0%​
Did SURGEON complete hand hygiene?
1​
1​
0%​
Did TRANSPORTATION complete hand hygiene?
1​
1​
0%​
Is Alcohol/Soap Dispenser filled?
1​
1​
0%​
Is Paper Towel Dispenser filled?
1​
1​
0%​
Grand Total
17​
17​
0%​
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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