Using IF and VLOOKUP to compare two values that are not similar (leading zeros for id)

Good morning,
I am trying to compare values in multiple sheets. Problem is the values generated from multiple databases is not identical. The ID has leading zeros in one, and not in the other; values generated are text in one and code in the other.
A combination of if and vlookup does not seem to work as I need to get a true or false in a third worksheet that I can give them as validation.
The formula I am trying to use is in the cell, as text which might help you point me to correct it.
Thanks in advance,

This works in your sample:

B2 of WorkingSheet (or Baseline) =INDEX(Possibility!B:B,MATCH(INDEX(Comparator!B:B,MATCH("*"&A2,Comparator!A:A,0)),Possibility!A:A,0))

Thank you so much, I appreciate all the help.
I guess I did not express my need correctly. I need to compare Possibility (1) on Baseline, to Possibility on Comparator (Yes), lookup that 1 and Yes are the same on sheet:Possibility and give me a "TRUE" in Working Sheet if identical/same or FALSE if not.

I don't understand. Perhaps include the desired results in your sample and re-upload it.

You can manually enter the desired results that you would like the formula to produce.

Thank you.
Please see sheet titled "2Check" wherein I have tried explaining what result I am looking for.

Try this in B2:

=A2+0=INDEX(Comparator!A:A,MATCH(INDEX(Possibility!A:A,MATCH(VLOOKUP(A2,Baseline!A:B,2,0)+0,Possibility!B:B,0)),Comparator!B:B,0))+0

Thank you so much, it worked like a charm!

Glad we could help.

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