Answer Happy

On the Charity sheet, use an inexact type of VLOOKUP to
calculate in the column
K how many tickets each donor will get for the charity ball by
looking into
the table in N4:O8. Copy down the column.
12. On the Charity sheet, nest the VLOOKUP inside an IFERROR
function so that if
an error occurred in column K, that cell will appear blank instead.
Copy down
the column.
13. On the Charity sheet, in the Status column, use a nested IF
function to display
the word “Inactive” when the This Year column is empty, display the
word
“New” when the Prev. Year column is empty, and display “Active”
otherwise.
(Hint: An empty cell will equal zero.)
(Do this in an excel Spreadsheet Please)