I have a lookup formula that returns the text "Direct" when nothing is found:

=IF(ISNA(VLOOKUP(B11,Sheet1!A:A,1,0)),"Direct",VLOOKUP(B11,Sheet1!A:A,1,0))

But I also want the text "associate" to appear when it is found - ie when it's true. I've tried changing my formula around, but I can't seem to do it.

Is there a better way at going about this?

Thanks