Forum Discussion
Solved
Indirect formula
Hello, The following formula searches the last cell with text in the sheet called '500 Amy' in column A. =LOOKUP(2,1/('500 Amy'!$A:$A<>""),'500 Amy'!$A:$A) I would like to replace '500 Amy' ...
INDIRECT for
'500 Amy'!$A:$A
will be
INDIRECT("'" & A1 & " " & B1 & "'!$A:$:A")
INDIRECT for
'500 Amy'!$A:$A
will be
INDIRECT("'" & A1 & " " & B1 & "'!$A:$:A")