May 01 2018
01:58 PM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
May 01 2018
01:58 PM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
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' with some sort like an INDIRECT formula so that I can reference the cells in column A and B to drag down the column.
For example,
A | B |
500 | Amy |
600 | Betty |
700 | Catherine |
A formula that looks like this but it shows an error.
=LOOKUP(2,1/('INDIRECT(A1&""&B1'!$A:$A<>""),'INDIRECT(A1&""&B1'!$A:$A)
Thank you.
Queenie
May 01 2018 03:36 PM
SolutionINDIRECT for
'500 Amy'!$A:$A
will be
INDIRECT("'" & A1 & " " & B1 & "'!$A:$:A")
May 01 2018 03:36 PM
SolutionINDIRECT for
'500 Amy'!$A:$A
will be
INDIRECT("'" & A1 & " " & B1 & "'!$A:$:A")