Returning Non-Zero Vlookup/match/index

Originally Posted by 63falcondude

Try this in B2:

=LEFT(INDEX(C$2:C$23,MATCH(1,(A$2:A$23=A2)*((LEFT(C$2:C$23,3)="PRO")+(LEFT(C$2:C$23,3)="BSA")+(LEFT(C$2:C$23,3)="PQR")),0)),7) Ctrl Shift Enter

This worked! Had to modify it but I tested it in the full code and it worked just fine.

Luckily I don't need to do this, but I am curious, since this is a CSE function, how would you get it to return a value besides #N/A for cells that didn't have a return, say for instance with my original example I had some full value "water" and the case number was also random, it wouldn't pull an abbreviated value, could I get that to return something other than #N/A?

Thank you I'll mark this as solved!