Forum Discussion
Solved
Index and match
Hi, i am trying to write an index formula for the following two tables. I want to write an array formula that returns 13 26 39 52 65 by matching 311.585 number from the following two ta...
Better to have sample file instead of screenshot, but for such model
formula could be
=OFFSET(INDEX(F:F,MATCH($K5,F:F,0)),COUNTIF($K$5:$K5,$K5),-2,1,6)
This works exactly how i wanted. Thank you so much.
jiwanjot , you are welcome