Vlookup returning different text to what it has found

[se15]

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

[dluhut]

Not tested...but try this

Please Login or Register  to view this content.

[se15]

That works great! And you answered in 3 minutes, genuis!

Cheers!

[Norie]

Try this.

Please Login or Register  to view this content.