PK!q@==[Content_Types].xmlPK! PK!docProps/core.xmlIFERROR Practice WorkbookXplorExcel.comFree IFERROR practice sheets with answer key — https://xplorexcel.com/iferror-excel/PK!0docProps/app.xmlXplorExcel Practice BuilderPK! xl/workbook.xmlPK!hhxl/_rels/workbook.xml.relsPK!bI xl/styles.xmlPK!d xl/worksheets/sheet1.xml01234567891011121314151617181920212223PK!Fw"c#xl/worksheets/_rels/sheet1.xml.relsPK!lxl/worksheets/sheet2.xml24252627282975530315553233885343531536375603839404142PK!] xl/worksheets/sheet3.xml43442526274546472829755148303155524932338853503435315451363756052PK!?Q xl/worksheets/sheet4.xml534454255556454647572871585960309261623263636434265368526628767303686977034571366PK!]W W xl/worksheets/sheet5.xml137273454674759148767559249773393507856094517980111588175511261828311363840PK!ٖOxl/sharedStrings.xmlIFERROR — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonIFERROR Function in ExcelAll Excel lessonshttps://xplorexcel.com/excel-tutorial/What’s insideIllustrationA fully worked example. Click any cell to see the formula.Practice Sheet 1Two tables. Pull the price onto every order line — one code is missing on purpose.Practice Sheet 2The same orders, but the missing code must read as words, not an error.Answer KeyEvery answer plus the exact formula that produces it.How to use it1Read the lesson first, then open the Illustration sheet.2Work through each Practice Sheet. Type formulas into the shaded cells.3Only then open the Answer Key. Compare your formula, not just your number.LicenceFree to use and share for personal study and classroom teaching. Please link back rather than re-hosting the file.Greenfield Academy — price list (deliberately unsorted)CodeItemPriceCODE-115SportsCODE-108TuitionCODE-101LabCODE-122TransportCODE-129LibraryWhat is happening here• IFERROR wraps a formula that might fail and gives you your own words instead of the error code.• The first argument is the formula itself; the second is what to show when it goes wrong. Write the lookup first, get it working, then wrap it.• IFERROR catches every error, including #REF! and #VALUE!. That is convenient and slightly dangerous: it hides genuine mistakes as well as missing values.• Never wrap a lookup before you have seen it work. Hiding an error you have not understood is how a wrong number reaches a customer.Greenfield Academy — price listSolve the following with the help of the VLOOKUP formula.#QuestionYour AnswerWhat price does CODE-115 carry? Look it up rather than reading it off.Which item is CODE-101?What price does CODE-129 carry?Look up CODE-999, which is not in the list. What does Excel show, and why?Type your formula in the shaded cells. Check yourself on the Answer Key sheet.Greenfield Academy — ordersOrderQtyUnit PriceORD-5001Fill Unit Price, showing "Not in list" when the code is missing instead of #N/A.→ fill in the tableORD-5002What does the missing code on row 11 show now?ORD-5003Show 0 rather than words, so the column can still be totalled.ORD-5004ORD-5005ORD-5006ORD-5007ORD-5008CODE-999ORD-5009ORD-5010Try every question before you read this. Compare the formula, not only the result.SheetFormula to useAnswer=VLOOKUP("CODE-115",B$4:D$8,3,FALSE)=VLOOKUP("CODE-101",B$4:D$8,2,FALSE)=VLOOKUP("CODE-129",B$4:D$8,3,FALSE)=VLOOKUP("CODE-999",B$4:D$8,3,FALSE) ← #N/A means not found — the formula is fine, the code is not there#N/A=IFERROR(VLOOKUP(C4,'Practice Sheet 1'!B$4:D$8,3,FALSE),"Not in list") ← write the VLOOKUP first, then wrap it=IFERROR(VLOOKUP(C11,'Practice Sheet 1'!B$4:D$8,3,FALSE),"Not in list") ← your words instead of the error codeNot in list=IFERROR(VLOOKUP(C11,'Practice Sheet 1'!B$4:D$8,3,FALSE),0) ← a number keeps arithmetic working downstreamPK!q@==[Content_Types].xmlPK! xl/worksheets/sheet3.xmlPK!?Q Ixl/worksheets/sheet4.xmlPK!]W W Vxl/worksheets/sheet5.xmlPK!ٖOaxl/sharedStrings.xmlPKz