Attach a note on a broken billing sheet, get each error explained with its real cause and fix, check the subtotal by hand, then get a safer lookup formula that shows "Add rate" instead of #N/A.
This lesson needs JavaScript. You can read every step here: ChatGPT: Fix #N/A, #VALUE!, #DIV/0! and #REF! Errors in Excel: the step-by-step guide, or browse all free AI automation tutorials.