Combine VLOOKUP with OR Function with three options

Hello! I'm frustrated because I cannot figure out how to do the following:
I want my VLOOKUP to bring back a value if it exists; if it doesn't, look in the same table for a different combination; if that doesn't exist, look on another tab; if it doesn't exist there, bring back #N/A
My formula is:
=IFERROR(OR(VLOOKUP(LEFT(A2,12),'SLIN rev'!A:B,2,FALSE),VLOOKUP(A2,'SLIN rev'!A:B,2,FALSE)),VLOOKUP(LEFT(A2,12),'UB SLINs'!A:B,2,FALSE))

It's not working....here's the breakdown of what I'm ATTEMPTING to accomplish:
VLOOKUP(LEFT(A2,12),'SLIN rev'!A:B,2,FALSE) = Lookup against this cell through 12 characters
IF it doesn't exist
VLOOKUP(A2,'SLIN rev'!A:B,2,FALSE)) = Lookup against this cell through the entire character field
If it doesn't exist
VLOOKUP(LEFT(A2,12),'UB SLINs'!$A:B,2,FALSE) = Lookup against a different tab (UB SLINs) and bring that value back

Any help would be greatly appreciated

EDIT:
I've attached a spreadsheet example

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

See the attached file.

B2 =IFNA(VLookup($A2,'SLIN rev'!$A$1:$B$5,2,0),IFNA(VLookup(LEFT($A2,12),'SLIN rev'!$A$1:$B$5,2,0),VLookup(Left(A2,12),'UB SLINs'!$A$1:$B$3,2,0))) and drag down.

Like this:

=IFERROR(VLOOKUP(A2&"*",'SLIN rev'!A:B,2,FALSE),VLOOKUP(A2&"*",'UB SLINs'!A:B,2,FALSE))

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.