How to use Offset in a table

Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match.
Take a look in the picture bellow. You will find out how to do it.

The complete formula is =OFFSET($B$4,MATCH(F15,B5:B9),MATCH(F16,C4:F4))
Offset and Match

 

Write a Reply or Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.