Not quite sure if the following is possible, but this is excel so of course it is
I want to be able to use the value in KR4, to dictate the starting point of the formula in KV4, an added complication is that the formula in KW4 is slightly modified, however, then dragged until KO4 is reached (notice the row 5 doesn't reach as far - because KO4 is reached early, due to the start being 252)
Any help on this would be massively appreciated
Mdn
I'm not entirely sure how everything is supposed to be interacting, but for starters, I changed the formula in KV4 to:
=MATCH(INDEX($B$4:$KO$4,1,MATCH($KR$4,$B$3:$KO$3,0)),$WO:$WO,0)-MATCH(INDEX($B$4:$KO$4,1,MATCH($KR$4,$B$3:$KO$3,0)+1),$WO:$WO,0)
...and the formula in KW4 to:
=IFERROR(KV4+MATCH(INDEX($B$4:$KO$4,1,MATCH($KR$4,$B$3:$KO$3,0)+COLUMN(A:A)),$WO:$WO,0)-MATCH(INDEX($B$4:$KO$4,1,MATCH($KR$4,$B$3:$KO$3,0)+COLUMN(B:B)),$WO:$WO,0),"")
Fill right, and the values in row 4 should respond to whatever is entered in KR4. Tweak the ranges and you can get the same effect in row 5. Take a look at the attachment to see if I'm on the right track. If something more is supposed to happen, please clarify what results you're expecting.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Hi Cantosh,
The problem is the formula isn't aware of the value in KR. Your formula only works if KR is set to 300; ideally, I'm looking to find a way that this is variable
the formula provided are all cell references ( variables )I'm looking to find a way that this is variable
did you tried to change the values in KR
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
As vlady indicated, the formulas are explicitly based off of KR4. If you change KR4, KS4 changes due to the lookup and KV4:WH4 adjusts to match the new value (see attachment with KR4<>300). If I'm misunderstanding the aim, can you clarify what it should be doing and what values it should return?
My mistake
Yes, you've done a brilliant job there Cantosh - massively appricated
haha, no worries. Glad I could help. Good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks