concatenate formula

[eamenon]

I have a formula which is in sheet1. The formula reads a
=IF(A1=1,SHEET2!A1*B1,""). I want excel to automatically change th
sheet name (SHEET2, SHEET3 etc.. as =IF(A1=2,SHEET2!A1*B1,"") as th
value in the cell A1 changes. As I have lot of worksheets involved,
find it difficult to apply the if command for all the cells. Please i
someone can help me out

 

[Frank Kabel]

Hi
try
=IF(ISNUMBER(A1),INDIRECT("'Sheet" & A1 & "'!A1")*B1,"")