An overview of the Portfolio Model About Formulas About Functions Quick Fx Guide - detailed info about required functions  

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%