Issues with vlookup with mid function output

I am having issues using the vlookup function with the output of a "mid" function embedded in it as the lookup value.

Formula is =vlookup(mid(cell,#,#),lookup array,2,false)

I know the mid formula is working correctly, but the vlookup isnt treating the mid function output as a number so it returns a #N/A result.

The formula I am trying to use is highlighted in column C of the attached workbook.

Please help!

The LEFT function treats numbers (digits) as Text.

Use this in C3 to convert to value, and drag down:

=VLOOKUP(VALUE(MID(B3,8,5)),P3:Q125,2,0)

This is perfect! Thank you

You're welcome.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved