VLOOKUP - return value from alternate sheet on match and specific text when no match

[hbhowser]

Hello Everyone!

I've searched and tried a number of variations of functions but am not getting a consistent result.
I'm hoping that there is some excel magic out there and I'm thinking that it's not too difficult but I can't seem to resolve.

The below function searches for the value in A2 in sheet '2016-2017'!A:B and returns the value from B when the name matches.
=VLOOKUP(A2,'2016-2017'!A:B,2,TRUE)

My challenge is when there is no match on the name in A2, I would like to return "Need #" to the primary sheet.

I've tried IFERROR, MATCH, etc and am not getting the syntax correct.

Any/all suggestions would be much appreciated!
Thank you

 

[Aladin Akyurek]

Thank you, thank you!
I've replace my last function with =IF(ISERROR(VLOOKUP(A8,'2016-2017'!A:B,2,FALSE)),"Need#",VLOOKUP(A8,'2016-2017'!A:B,2,FALSE)) ... and it's working.
Again - much appreciated!

=IFERROR(VLOOKUP(A8,'2016-2017'!A:B,2,0),"Need#")

Replace IFERROR with IFNA if you have this on your system.