IF(ISNA...) with VLOOKUP on another worksheet to return "M" if not present on other worksheet?

[kznmrexcel]

Hi, everyone,

I have two worksheets with a list of students on each one, "lib_checkin" and "lib_hah." Only some of the students on "lib_checkin" are listed on "lib_hah," along with the period that they have a class.

If they ARE listed on "lib_hah," I want to return the value of what period that they are in class on the "lib_checkin" sheet, which is currently working.
If they are NOT listed on "lib_hah," I would like to get the result returned as just the letter M, but right now, I'm getting #NAME? instead.

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #006107}span.s2 {color: #ab30d6}span.s3 {color: #0057d6}</style>=IF(ISNA(VLOOKUP(A15,lib_hah!$A:$G,5,0)),”M”,VLOOKUP(A15,lib_hah!$A:$G,5,0))


Any help is appreciated.
Thanks,
Karen

 

[sandy666]

maybe problem is with: ”M”, try "M"

 

[kznmrexcel]

That did it. Thank you!

 

[sandy666]

You are welcome

Have a nice day

 

[Peter_SSs]

If you are using Excel 2013 (I think) or later, you can write that formula more simply as:

=IFNA(VLOOKUP(A15,lib_hah!$A:$G,5,0),"M")


For some older versions you could also use this unless it is specifically #N/A errors that you are trying to trap

=IFERROR(VLOOKUP(A15,lib_hah!$A:$G,5,0),"M")