Hi guys,
I've having a little problem with the LOOKUP formula, I have a range of 31 sheets "1:31" where there might be data in their cells , for sake of this examples let's use A1
So we have 31 A1s in a range of "1:31" and then I will create a Sheet "32" where its A1 needs to return or be equal to the last valid data found in the prior 31 A1s of the range.
So if the last of the A1s that has data is on sheet "20" then the A1 on sheet "32" has to be equal to A1 on sheet 20.
=LOOKUP(2,1/('1:31'!L5<>""),'1:31'!L5)
This formula should do the trick or am I incorrect?( I'm not an expert I'm just following what I have found on the internet )
The problem I have while I'm updating the range on this formula is that once is hit enter it transforms into this =LOOKUP(2,1/('1:[31]31'!L5<>""),'1:31'!L5) and I just get a #REF! error
Would greatly appreciate any help
Thanks!
I've having a little problem with the LOOKUP formula, I have a range of 31 sheets "1:31" where there might be data in their cells , for sake of this examples let's use A1
So we have 31 A1s in a range of "1:31" and then I will create a Sheet "32" where its A1 needs to return or be equal to the last valid data found in the prior 31 A1s of the range.
So if the last of the A1s that has data is on sheet "20" then the A1 on sheet "32" has to be equal to A1 on sheet 20.
=LOOKUP(2,1/('1:31'!L5<>""),'1:31'!L5)
This formula should do the trick or am I incorrect?( I'm not an expert I'm just following what I have found on the internet )
The problem I have while I'm updating the range on this formula is that once is hit enter it transforms into this =LOOKUP(2,1/('1:[31]31'!L5<>""),'1:31'!L5) and I just get a #REF! error
Would greatly appreciate any help
Thanks!