This is a sort of follow-up question to one of my earlier posts on this forum (sorry unable to post the link since posting of html tags is probably prohibited), wherein I wanted to lookup a value from the bottom of a column range, ignoring the last 5 rows.
The formula I am using issince it addresses my requirement of lookup for non-numeric values.
Please Login or Register to view this content.
I am however using the lookup function for almost 50 columns with 3000 rows and that is slowing down my calculations considerably (data being updated in real time). Since the same formula is being repeated for same row no. across all 50 columns with only the lookup column changing, I guess it would be faster if I could get the Row no. (similar to Match function) and use Indirect function to get data in the same row no. from all 50 columns.
So the request is, can I modify the above formula to get the row no. instead of the the actual value (similar to Match Function from bottom of range ignoring last 5 rows).
Sample File attached