Comparing cells via Vlookup then returning text

[antinora]

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

 

[JoeMo]

Untested, but try this:

=IF(ISNA(MATCH(A2,abs!$A1:$A$748,0)),"Present","Absent")

 

[Momentman]

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

I would prefer to use a MATCH function but following your convention, try the below

 IF(ISNA(VLOOKUP(A2,abs!$A$1:$A$748,1,FALSE)),"Present" ,"Absent")

 

[MuchToLearn]

Assuming old Student ID are unique in each sheets, and Student ID in 'sheet abs' is subset of Student ID in "sheet1", why not just use =IF(COUNTIF(abs1!$A$1:$A$748, A2)=0,"Present","Absent"))?