#NO MATCH Error when using VLOOKUP to look up the text displayed on a hyperlink



I'm trying to use vlookup to return data (a version number) using match data (document numbers). I have the VLOOKUP formula as =VLOOKUP([Document Number]1, {OP - Smartsheet Master Document List Range 2}, 7, false)


[Document Number]1 is a text/number column on the sheet I am working in

{OP - Smartsheet Master Document List Range 2} is a link to another smartsheet, where the document numbers are - but these cells contain a hyperlink

I'm getting a no match error with this set up. Any advice or alternative solutions?

Thank you