Syntax required to merge two formulas

[robertguy]

Hi,

Can any advise me of the syntax required to merge these two formulas

Please Login or Register  to view this content.

=IF('InPut'!A2="","",'InPut'!A2)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

=INDIRECT("'InPut'!A"&ROW(A2))

Please Login or Register  to view this content.

Any assistance would be greatly appreciated


Many thanks in advance

Regards

[AliGW]

This maybe:

=IF(INDIRECT("'InPut'!A"&ROW(A2))="","",INDIRECT("'InPut'!A"&ROW(A2)))

[xlnitwit]

Hi,

You could use
=IF(INDIRECT("'InPut'!A"&ROW(A2))="","",INDIRECT("'InPut'!A"&ROW(A2)))
or the non-volatile
=IF(INDEX('InPut'!A:A,ROW(A2))="","",INDEX('InPut'!A:A,ROW(A2)))

[robertguy]

AliGW & lnitwit,

many thanks for your very fast responses its just what I required

Thanks again

Regards

Rob

[AliGW]

You're welcome!