Hi Guys,
I'm trying to reference arrays and embed them in other formulas. For this to work how I want, I want to make the array length a variable. Is it possible for example if I have the following formula:
=INDEX(A1:A10,MATCH(C1,B1:B10,0),1)
Is it possible to make the A10 let's extend to A200 and the B10 extend to B200 by specifying in let's say Cell D1 the row I want to go to? How would I do so? Let's assume now Cell D1 is set to 10 to match the formula above.
Thanks!
Larry G.
Maybe:
=index(OFFSET(A1,0,0,D1,1),MATCH(C1,OFFSET(B1,0,0,D1,1),0),1)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
If you prefer index since it's not volatile, see if that is what you have in mind:
=INDEX(A1:INDEX(A:A,D1),MATCH(C1,INDEX(B1:INDEX(B:B,D1),),))
Last edited by RaulSerg; 05-28-2020 at 05:04 PM. Reason: typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks