Populate Data From Another Sheet With Criteria

[jag.seven]

Hi,

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.

Appreciate help.

[h1h]

in C7 on sheet staff :
=VLOOKUP(A7;Data!$A$3:$W$6;MATCH(Staff!$A$3;Data!$A$2:$W$2);FALSE)

[jag.seven]

Thank you ! That worked.