| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee | Answer | ||||||||||||
| 2 | Kofi | #REF! | ||||||||||||
| 3 | Lena | |||||||||||||
| 4 | Mo | |||||||||||||
| 5 | Nia | |||||||||||||
| 6 | ||||||||||||||
| 7 | ||||||||||||||
| 8 | ||||||||||||||
| 9 | ||||||||||||||
| 10 | ||||||||||||||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | ||||||||||||||
| 14 | ||||||||||||||
| 15 | ||||||||||||||
| 16 | ||||||||||||||
| 17 | ||||||||||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | ||||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 | ||||||||||||||
| 25 | ||||||||||||||
| 26 | ||||||||||||||
| 27 | ||||||||||||||
| 28 | ||||||||||||||
| 29 | ||||||||||||||
| 30 |
Common causes
- A position or column number is bigger than the range, as in a VLOOKUP asking for column 5 of a three-column table.
- Count the columns again, or use XLOOKUP, which needs no column number.
- Rows, columns or a sheet that the formula referred to have been deleted.
- Undo the deletion at once, or rewrite the formula to point at cells that exist.
- A formula was copied to a place where its relative references fall off the sheet.
- Lock the references that should not move with dollar signs before copying.
- INDIRECT was given text that is not a real cell address.
- Check the text it is built from.
Functions involved
Other errors