VLookup with Multiple Values

Manny74

Board Regular
Joined
May 6, 2016
Messages
103
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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
I suggest to update your profile about Excel version & OS and use XL2BB to post representative source example and expected result (not a picture)
 

Manny74

Board Regular
Joined
May 6, 2016
Messages
103
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....

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?
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
the blue XL2BB is a link to instruction and download
 

Manny74

Board Regular
Joined
May 6, 2016
Messages
103
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

the blue XL2BB is a link to instruction and download
I have read the instructions and I dont understand them....Is there another way I can attach my sample MS Excel file?
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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
 

Manny74

Board Regular
Joined
May 6, 2016
Messages
103
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

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....
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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:

Manny74

Board Regular
Joined
May 6, 2016
Messages
103
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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%​
 

Watch MrExcel Video

Forum statistics

Threads
1,127,934
Messages
5,627,697
Members
416,266
Latest member
stevenvanroeden

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
Top