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!
Bookmarks