I currently have data that has a date and item number and I'm looking to pull the price from a different sheet.
=Vlookup(#,Jan1!(Range),2,0)
Gives me my price of Jan 1
=Vlookup(#,Jan3!(Range),2,0)
Gives me my price of Jan 3
The problem is that each date has its own sheet but I want a single formula to find the date of the data to reference the sheet correlating to that date.
My end goal is to have a formula that references the date to go and do a vlookup
on the related sheet.
=Vlookup(#,[Order Date's Referenced Page](Range),2,0)