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)
The lookup value will always be in 4th column
second answer is that it there is a predefined size to the array
Please see attached
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