Vlookup formula responds selectively for some and not all values

Hello,
=IF(G88="PT",VLOOKUP(B88,Vlookup1!A:R,5),IF(G88="OT",VLOOKUP(B88,Vlookup1!A:R,6),IF(G88="ST",VLOOKUP(B88,Vlookup1!A:R,7),FALSE)))

Two tabs in an excel spreadsheet. One with this formula and another one named Vlookup1 with the info (three columns indicating diagnosis codes for PT (Physical Therapy), OT (Occupational Therapy) and ST (Speech Therapy).

Out of approximately 350 rows, this formula works perfectly fine with all but three customers’ names. It seems to be only with the last three customers –sorted alphabetically– and can’t figure out how to solve it.
Have reduced the amount of rows in the info tab / have changed the format of all cells for these 3 customers / have retyped all information under another row and inserted above all the conflict rows but it always brings “0” as the cell value – not even False….

Help!!

change all to this format then it will only look for exact match
VLOOKUP(B88,Vlookup1!A:R,5,false) then come back with what doesnt match .probably spaces or something you havent noticed

Can be shortened to:

=VLOOKUP(B88,Vlookup1!A:R,LOOKUP(G88,{"OP","PT","ST"},{6,5,7}),FALSE)

and includes FALSE qualifier.. maybe they aren't actually sorted as you think..

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save