200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
=IF(VLOOKUP(F21, Tallie1!$C:$F, 4, FALSE) = "absent", P21, "")
is the formula, which works, however, for the cells that don't qualify I would like them to be blank..so I tried....
IF(ISERROR(VLOOKUP(F21, Tallie1!$C:$F, 4, FALSE) = "absent", P21, "")
But still no resolve...Please assist
Use IFERROR function if you are in Excel 2007 or later.
=IFERROR(IF(VLOOKUP(F21, Tallie1!$C:$F, 4, FALSE) = "absent", P21, ""),"")