Modul 1 · Grundlagen und SUMME
XLOOKUP at Polar Scoops

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
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
- Select the cell for the result.
- Type =XLOOKUP(
- Click the value to find. Type a comma.
- Type the column to search in, for example H:H. Type a comma.
- Type the column with the results, for example I:I. Type a closing bracket.
- Press Enter.
=XLOOKUP(C5,H:H,I:I)Aufgabe: Find the price for order #102. Put it in cell E6.
Copy the formula down
Fill Down copies a formula to the cells below. Excel changes the row number in each copy.
So geht es
- Select the cell with the formula and the empty cells below it.
- To select a range, click the first cell, hold Shift and click the last cell.
- 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.
Add numbers with AutoSum
AutoSum writes a SUM formula for you. It selects the numbers above the cell.
So geht es
- Select the cell below the numbers.
- On the Home tab, click AutoSum. Or press Alt+=. On a Mac, press ⌘⇧T.
- 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.