Hello,
I am using Microsoft Excel for Mac ver 15.3, and I am trying to combine the LOOKUP and IFERROR formulas to pull data from sheet 1 titled Student List to another sheet in the workbook named Student Information Form. It works fine except when the cell on the source sheet is blank. If a student name is blank, then I get a "0" value in the form sheet cell, and if the birthday is left blank, I get "January 1, 1900" in the form sheet cell. The Birthday cell is formatted as Date. I have used this formula below and get the desired results when data is located in the source sheet, but I cannot figure out how to insert the message "Not Listed in Master" when the source cell contains no data.
=IFERROR(VLOOKUP(B2,'Student Sheet'!B4:S40,[column number],False),"Not Listed in Master")
If anyone has a workable solution, I would be grateful for a reply.
Thanks
Bookmarks