Modul 1 · Grundlagen und SUMME · XLOOKUP at Polar Scoops
Die Tabelle lädt …

Modul 1 · Grundlagen und SUMME

XLOOKUP at Polar Scoops

Mia
Mia owns Polar Scoops, an ice cream shop

Saturday was a busy day. Eight orders have no price. Mia has a price list, but no time. You help her.

Schritte

  1. Find a price with XLOOKUP

    XLOOKUP finds a value in one column. Then it gives back the value from the same row in a different column.

    So geht es

    1. Select the cell for the result.
    2. Type =XLOOKUP(
    3. Click the value to find. Type a comma.
    4. Type the column to search in, for example H:H. Type a comma.
    5. Type the column with the results, for example I:I. Type a closing bracket.
    6. Press Enter.

    =XLOOKUP(C5,H:H,I:I)

    Aufgabe: Find the price for order #102. Put it in cell E6.

  2. Copy the formula down

    Fill Down copies a formula to the cells below. Excel changes the row number in each copy.

    So geht es

    1. Select the cell with the formula and the empty cells below it.
    2. To select a range, click the first cell, hold Shift and click the last cell.
    3. Press Ctrl+D. On a Mac, press ⌘D.

    E7 now contains =XLOOKUP(C7,H:H,I:I)

    Aufgabe: Fill in the prices for all orders. The last cell is E12.

  3. Add numbers with AutoSum

    AutoSum writes a SUM formula for you. It selects the numbers above the cell.

    So geht es

    1. Select the cell below the numbers.
    2. On the Home tab, click AutoSum. Or press Alt+=. On a Mac, press ⌘⇧T.
    3. Make sure that Excel selected the correct range. Then press Enter.

    =SUM(D5:D12)

    Aufgabe: Find the total sales. Put the sum of column F in cell F13.