Using Vlookup with multiple sheet
As long as your sheet names *exactly* match the column dates and the lookup
table is in the *exact* same location on each sheet.
B1:F1 = 4-Jan-08 18-Jan-08 1-Feb-08 15-Feb-08 29-Feb-08
A2 = Rusty Brown
Enter this formula in B2 and copy across then down as needed (adjust the
range of the lookup table to suit):
=VLOOKUP($A2,INDIRECT("'"&TEXT(B$1,"d-mmm-yy")&"'!A1:B10"),2,0)
--
Biff
Microsoft Excel MVP
"Jammings" wrote in message
...
I am trying to update data on mutiply sheet into one spreadsheet
This is a fornightly payroll workbook where each sheet is the date of the
fornight payment. After I set up the vlookup formulae to pick up the first
pay period in say colum c. Can I edit the formulae to pick up data in the
next sheet, without actually typing in the sheet name or using find and
replace.
Staff 4-Jan-08 18-Jan-08 1-Feb-08 15-Feb-08 29-Feb-08
Rusty Brown 0 14,300 10,300 14,300
Uton COUBOURNE 0 28,375
Ernol FOX 0 22,454
Anseka Gibson 0 14,300
|