Cell reference from indirect rather than blank cell

[lian.cragg]

Not sure if i should use the code wrap here, don't want to get in trouble though.

How do I get the result of the indirect funtion to actually show the cell reference in this case ('asset sheet'!$B$43) as text in the cell? At the moment that will result in a blank cell.

Please Login or Register  to view this content.

Thank you

[romperstomper]

Remove the INDIRECT function.

[lian.cragg]

If i remove the indirect function how do i find out the last cell in the other sheet?

[romperstomper]

You said you wanted the cell reference. The INDIRECT function is being passed the cell reference as a string, which it then converts into the value of that cell, so if you remove the INDIRECT function, you are left with the string itself:
=IF(LEFT(A2,7)="HP 7800",$I$1&"!"&"b"&COUNTA('HP 7800 PC'!B:B),"not working2")

[lian.cragg]

Lovely thank you :o)