Excel 2007 : How can I get diferent sheet names in the formula

[stojko89]

Hi

My problem is this:

I'm using this

Please Login or Register  to view this content.

In my attached file this is in colum JA/Ne/Delno (Colum I)
In colum A I have hiperlinks made to Sheets
Is it possible to make the part where the sheet name is entered so it changes with every row to its name like this:

If it's row 1 the code is this

Please Login or Register  to view this content.

If its row 4 the code is this:

Please Login or Register  to view this content.

The name of the work sheet in the formula changes. the part in ' '

Thank you

[TMS]

Try using Indirect (in Row 4):

=IF(INDIRECT("'"&TEXT(ROW(A4);"00000")&"-2011'!F2")="";"Ne";IF(INDIRECT("'"&TEXT(ROW(A4);"00000")&"-2011'!F2")="V celoti dobavljen material";"Ja";"Delno"))


This should change the sheet number to reflect the row number

Regards

[stojko89]

Thank you very much

I had to use this

Please Login or Register  to view this content.

But now it works great. If I didn't put the IF Empty part at the begining it would show me an error where the seet names aren't yet put

It is strange that I have to have the above formula in I2 that refers to cell A2 <--- this is normal what I don't get is why the formula doesn't work in cell I2 if I put it like this

Please Login or Register  to view this content.

The changed part is ROW(A2) insted of ROW(A1)

[Alastairr]

Thank you very much.