1) Change the Income Amount in Cell B3.
2) Watch the amounts change in cells C4 and H4.
3) Look at the formulas in C4 and H4. They use the lookup function to compare the part number in B3 to the numbers in C6:F6, and "scan" the array table values in C7:F12 to find the sales in units for each month. The number at the end of the formula indicates the row of the array table from which the value should be pulled. In HLOOKUP, the row of heading labels (i.e. part #s)counts as the first row.
| FIN 615 HLOOKUP Example |
|
|
|
|
|
|
|
|
Unit Sales |
|
|
|
|
| Part #: |
D20B3 |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
|
|
331 |
325 |
341 |
339 |
365 |
372 |
|
|
|
|
|
|
|
|
| Part # |
|
D20B2 |
D20B3 |
D20B4 |
D20B5 |
|
|
| January |
|
123 |
331 |
285 |
475 |
|
|
| February |
|
128 |
325 |
287 |
525 |
|
|
| March |
|
126 |
341 |
266 |
577 |
|
|
| April |
|
124 |
339 |
275 |
584 |
|
|
| May |
|
130 |
365 |
289 |
596 |
|
|
| June |
|
133 |
372 |
295 |
634 |
|
|
