Difficulty 2 of 5 · about 3 min
Show a friendly message when XLOOKUP finds nothing
Invoice numbers are in A2:A7, client names in column B and invoice amounts (INR) in column C. Three invoice numbers to check are typed in D2:D4. In E2, write ONE formula that returns the amount for each of those invoices, spilling down E2:E4. If an invoice number is not in the list, the cell must show the text Not found instead of an error. Use XLOOKUP.
Loading grid…