XNUMXD Search in Excel

In this example, we will explain to you how to search for values ​​in a XNUMXD range. We will use the functions MATCH (MORE EXPOSED) and INDEX (INDEX).

In the figure below, you can see a graph of the sales of different types of ice cream in each month.

1. To find the line number Feb (February), use the function MATCH (MORE EXPOSITION):

   =MATCH(G2,A2:A13,0)

   =ПОИСКПОЗ(G2;A2:A13;0)

2. To find the column number Chocolate (chocolate), use the function again MATCH (MORE EXPOSITION):

   =MATCH(G3,B1:D1,0)

   =ПОИСКПОЗ(G3;B1:D1;0)

3. To find chocolate ice cream sales in February, use the function INDEX (INDEX):

   =INDEX(B2:D13,H2,H3)

   =ИНДЕКС(B2:D13;H2;H3)

4. Now put everything together:

   =INDEX(B2:D13,MATCH(G2,A2:A13,0),MATCH(G3,B1:D1,0))

   =ИНДЕКС(B2:D13;ПОИСКПОЗ(G2;A2:A13;0);ПОИСКПОЗ(G3;B1:D1;0))