antinora
Board Regular
- Joined
- Dec 4, 2013
- Messages
- 87
- Office Version
- 365
- 2016
- Platform
- Windows
I'm blanking on a nested If statement. I have 2 worksheets. In sheet 1 a a list of student ID numbers. In sheet 2 is a list of student ID numbers for daily absentees. I want to compare both columns of IDs and return Presents if m atch else Absent.
Since no match returns #N/A the formula I'm using returns Present but I want Present else Absent.
I'm using =IFERROR(VLOOKUP(A2,abs!$A$1:$A$748,1,FALSE),"Present")
Is there a If then else vlookup type nested formula?
Thank you
Since no match returns #N/A the formula I'm using returns Present but I want Present else Absent.
I'm using =IFERROR(VLOOKUP(A2,abs!$A$1:$A$748,1,FALSE),"Present")
Is there a If then else vlookup type nested formula?
Thank you