I hope the thread title is correct.
I have a spreadsheet which I need to populate the data from sheet based on current date.
Cell C7 in the "Staff" tab needs to update from tab "Data" for John based on the current date . The current date is located in cell A3 in the "Staff" tab.
On daily basis, as I open the spreadsheet , cell C7 should update from the "Data" tab automatically based on the date in cell A3 in the "Staff" tab.
Example, on January 4 2008, cell C7 should populate as 2 from the "Data" tab.
I tried using the IF formula, but I cant expand the formula for the whole month of January since it is limited only to 7 arguments.