Alan Beban wrote...
....

OP's original table

___A__ ____B____ ____C__________ ____D____
050505 04-121212 050505 - CO.fsa (formula here)
050452 05-214176 050505 - CO.fsa
052121 03-217496 050505 - CO.fsa

AB's original formula

=VLOOKUP(--LEFT(CELL("contents",INDEX(Tbl1,ROW(A3),3)),5),Tbl 1,2,0)

Not a failure to test. I tested on a 3-row range and simply
mistakenly
copied the formula from the 3rd row instead of from the first row when

pasting into my posting. Thanks for pointing it out.

More BS from you.

If col A row 1 were a number formatted as "000000", then your 1st arg
to LOOKUP, no matter which col C cell you used, would be 5050, *NOT*
50505, so your VLOOKUP formula would have returned #N/A. If col A row 1
were text, then even if you had used the first 6 chars from any of the
col C cells, you'd have converted the first VLOOKUP argument to a
number which couldn't match *ANY* text values in col A, so again your
VLOOKUP formula would have returned #N/A. Didn't test using the OP's
data either, did you?