Microsoft Excel Functions & Formulas

Dynamically showing costs and sales per day

The table in Figure 14-46 contains cost and sales values per day.

After entering the desired date, the corresponding cost and sales

values should be found and displayed.

4

To dynamically show costs and sales per day:

1. Using the data shown in Figure 14-46, select cell C5.

2. Type the formula =HLOOKUP($B$5;$B$8:$G$10;2;

FALSE).

3. Press <Enter>.

4. Select cell D5.

5. Type the formula =HLOOKUP($B$5;$B$8:$G$10;3;

FALSE).

6. Press <Enter>.

380

Chapter 14

Figure 14-46

For this example, it is also good to use conditional ...