Forum Discussion
Index and match
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)
hi i want a formula that looks up these two tables based on my lookup value of 311.535 or 311.585 and returns an array that starts from second column and second row
and lookup value could be in any position or always in the 4th column from the range start? Other words, how do we know where is the first column of the range.
Second row as I understood is the next to the one in which the value found.
Another question is what is the logic of how to find end of the range - is it of predefined size or it shall be found based on some logic.
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.
