Formula help: Use sheetName as a variable 1

[dswitzer]

I have a summary page that looks up various pieces of data in other pages (same workbook). I would like to copy the formulas down instead of editing (or find/replace although that is an option).

For example:

sheetName formula
sheet1 =if(sheet1!A1=sheet1!A2,"OK","ERR")
sheet2

If I copy the formula down to the next cell, I want sheet1 replaced by sheet2 (the value in the cell to the left).

Hopefully that made sense...

Thanks.

 

[SkipVought]

Hi,

Take a look at the INDIRECT function. Concatenate the sheet name and the cell reference.

Skip,

_[red][/red]

 

[dswitzer]

Yep - that'll do it. Not exactly a function I would have looked at by name but it makes sense now...

Thanks.