If statement combined with VLOOKUP to return specific text?

[kznmrexcel]

Hi, everyone,

I'm using a VLOOKUP to determine whether students are listed on a separate sheet which shows that they have a district laptop checked out to them. The VLOOKUP is working fine by itself:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}</style>=VLOOKUP(A2,CBdistrict2!$A:$E,5,FALSE)

However, I would like to have an IF statement that returns the text "CB District" if they are on this list, and the text "Standard" if the value is #N/A, meaning that they are NOT on this list. I'm not quite sure how to go about this. Any help is appreciated.

Thanks,
Karen

 

[admiral100]

Hi,

Maybe this : =IF(ISNUMBER(IFERROR(VLOOKUP(A2,CBdistrict2!$A:$E,5,FALSE),"Standard")),"CB District","Standard")

 

[Aladin Akyurek]

=IF(ISNUMBER(MATCH(A2,CBdistrict2!$A:$A,0)),"CBDistrict","Standard")

would be adequate for the job and fast.