jglassnerHI
New Member
- Joined
- Feb 2, 2016
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
- MacOS
I am looking for help with looking up two values to return a third.
My thought is a VLOOKUP something like this =VLOOKUP(Y5&Y6,data,column,0) but this doesn't work. Is the issue since I am looking up from the drop-down menu? Both columns have duplicate values. Example: We have the same department 9 different times but only 3 chiefs.
On the report page, I have two drop-down menus. I want to select from Y5 and Y6 to return the department chief.
All of this information is in a table named "Shared Dataset"
Thanks for your help, I have watched different videos and some of them are really complicated and the simple ones do not work.
Jason
My thought is a VLOOKUP something like this =VLOOKUP(Y5&Y6,data,column,0) but this doesn't work. Is the issue since I am looking up from the drop-down menu? Both columns have duplicate values. Example: We have the same department 9 different times but only 3 chiefs.
On the report page, I have two drop-down menus. I want to select from Y5 and Y6 to return the department chief.
- Department
- Work Location
- I want it to return the department chief name
All of this information is in a table named "Shared Dataset"
Thanks for your help, I have watched different videos and some of them are really complicated and the simple ones do not work.
Jason