Hello Excel-lent,
In our last discussion on VLOOKUP, we talked about VLOOKUP and its cousins HLOOUP, MATCH, INDEX and CHOOSE and also about many of us been used to One-column VLOOKUP. click here if you missed it please http://excelgist.blogspot.com.ng/2015/09/21-lookup-reference-vlookup-part-2.html
Now let's see how we can use VLOOKUP for a 2-way lookup in the below example. 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
2. To find the column number of Chocolate, use the MATCH function.
3. To find the sales of Chocolate in February, use the INDEX function.
4. Put it all together.
You can try replace the vanilla products using 3 Nigerian banks and see how it comes out, changing the months and the products or bank names as you wish to see the effect of the 2 column lookup.
We would not have achieved this using the VLOOKUP function alone, many thanks to it's cousins; MATCH & INDEX
Be good, be excel-lent!
Oladapo Sorinola
07014282477, 07062932708BB Pin 52E9802D
No comments:
Post a Comment