# Functions

**10**Pins

**477**Volgers

The VLOOKUP function looks for the ID (104) in the leftmost column of the range $E$4:$G$7 and returns the value in the same row from the third column (third argument is set to 3). The fourth argument is set to FALSE to return an exact match or a #N/A error if not found.

*2*

#### Excel Lookup & Reference Functions

To create an absolute reference to cell H3, place a $ symbol in front of the column letter and row number of cell H3 ($H$3) in the formula of cell E3. Now we can quickly drag this formula to the other cells. The reference to cell H3 is fixed (when we drag the formula down and across). As a result, the correct lengths and widths in inches will be calculated.

*1*

#### Excel Cell References

By default, Excel uses relative reference. For example, cell D2 references (points to) cell B2 and cell C2. Now, select cell D2, click on the lower right corner of cell D2 and drag it down to cell D5. Cell D3 references cell B3 and cell C3. Cell D4 references cell B4 and cell C4. Cell D5 references cell B5 and cell C5. In other words: each cell references its two neighbors on the left.

*1*