This example teaches you how to lookup a value in a two-dimensional range. We use the MATCH and INDEX function.
Below you can find the sales of different ice cream flavors in each month.
1. To find the row number of Feb, use the MATCH function.
Match Function
2. To find the column number of Chocolate, use the MATCH function.
Match Function
3. To find the sales of Chocolate in February, use the INDEX function.
Index Function
4. Put it all together.
Two-way Lookup Result
Did you find this information helpful? Show your appreciation.

Post a Comment

Blogger Tips and TricksLatest Tips And TricksBlogger Tricks


Cloud Power For You

Website Hosting At Low Price


Empire Views