Microsoft Excel Functions & Formulas

Use the HLOOKUP function to generate a list

for a specific month

The dates on which errors occur in a system are recorded each

month in an Excel table as shown in the following figure. The first

column lists the dates of all errors that occurred in a certain month.

Enter in cell A1 the month and use a combination of functions

based on HLOOKUP to return all recorded dates.

4

To generate a list for a specific month:

1. In a worksheet, copy cells C2:F5, as shown in Figure 9-9.

2. In cell A1 type the month 11.

3. Select cells A3:A8 and type the following formula:

=IF(HLOOKUP($A$1,$C$2:$F$11,ROW()-1,FALSE)=

0,"",HLOOKUP($A$1,$C$2:$F$11,ROW()-1,FALSE)).

4. Press ...