Triple Vlookup?

mattyblueice

Board Regular
Joined
Jul 24, 2014
Messages
91
Office Version
  1. 365
Platform
  1. MacOS
HI - I am trying to put together a sheet to identify what month various tasks were performed at a number of sites. This seems like I might need a triple Vlookup, but not sure if there is another way. I would appreciate any suggestions. On the left side is a mock database and on the right, Column F will have all of sites and in column G:J I want to have formulas to reference the database A3:C6 to return the date the task was performed.

Thanks

1733763481068.png
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Try:
\
Book1
ABCDEFGHIJ
1
2TaskSiteMonthSiteTask ATask BTask CTask D
3Task APhoenix24-OctPhoenix24-Oct   
4Task BSeattle24-NovSeattle 24-Nov  
5Task CMiami24-DecMiami  24-Dec 
6Task DOakland24-OctOakland   24-Oct
Sheet8
Cell Formulas
RangeFormula
G3:J6G3=FILTER($C$3:$C$6,($A$3:$A$6=G$2)*($B$3:$B$6=$F3),"")
 
Upvote 0
Solution
Son of.... lol Thank you so much Cubist - that worked perfectly. Happy Holidays!
 
Upvote 0

Forum statistics

Threads
1,224,755
Messages
6,180,751
Members
452,996
Latest member
nelsonsix66

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