I am creating a weekly dashboard using data from file that stores a years worth of data
I want to pull the data in a column if the two dates match on both the dashboard and the data file
I have tried HLOOKUP and IF but have had no success
the data pull will also need to skip certain columns that total weekly and monthly
please see attachment
Bookmarks