
 
Q-
Fx Guide
        
        
        
        


 |
With This
Function:
|
|
1. |
Excel Horizontally Looks
up the VALUE of Cell
Q2
In this case "INTC" (see Figure 2 below), |
|
2. |
Excel Searches
in the TABLE
Named Raw in the example (see
Figure 3), |
|
3. |
Because the argument says False,
Excel stops when it EXACTLY finds the VALUE ("INTC"), |
|
4. |
Excel Then,
identifies the Cell that VALUE is found
("INTC") and labels it Row "1"
(NOTE: that the row might be actually #2, #15,
or any
other row but, the function disregards
all rows above of the cell containing the VALUE
looked for), |
|
5. |
Starting with the Row containing the VALUE ("INTC")
AKA Row #1, and
moving downward,
Excel displays the
data that is found in the 7th row.
|
|
6. |
Excel displays the results in Cell
Q8.
Final answer displayed: "-4%" |

NOTE:
• If you change Q2,
to "F" (w/o quotes), then the data displayed changes to -18%
(cell B8 in Raw)
• If you change the formula VALUE from Q2 to
P2, Excel looks for JNJ
in Table Raw & displays 1%
|
|