If Vlookup finds result, return specific "Phrase"

I did contribute, thank you .

Originally Posted by Jonmo1

Try

=IF(AA6="Series","Wound Care",IFERROR(VLOOKUP(S6,Assumptions!$B:$E,4,FALSE),"HIM"))

Originally Posted by rwmeis

Your formula above worked unfortunately my logic was off sequentially. Thank you for the help though!