Reference to Previous Sheet

[marka87uk]

Hi,

I do a weekly report where each new week is added as a new sheet named by date, e.g. 'wc 4th July', 'wc 11th July', 'wc 18th July' and so on.

Part of the report needs to check if an employee appears on the previous week and I currently do this with a VLOOKUP but it involves manually changing the lookup table each week (not a big problem I know, but it's possible errors could occur with this method if the formula is not changed or an incorrect date is entered).

e.g. on the 'wc 18th July' sheet I use this formula:
=IF(ISERROR(VLOOKUP(C2,'wc 11th July'!C:K,8,FALSE)),"-",VLOOKUP(C2,'wc 11th July'!C:K,8,FALSE))

Is there any way to reference to the previous sheet so the formula would not need to be changed?

Thanks!

 

[Andrew Poulsom]

There's a custom function here:

http://spreadsheetpage.com/index.php/tip/a_custom_function_for_relative_sheet_references/

 

[marka87uk]

Thanks, I'll check it out.