I'm trying to use VLOOKUP to pull data from one tab in a Google Sheets workbook into another tab. The VLOOKUP formula works if the value being searched for is
100103, but not the cell reference G2 (which displays
Formula In G2
=arrayformula(iferror(regexextract(regexextract(F2:F, "ID#\d+"), "\d+")))
Shared Copy Of Original Google Sheet
VLOOKUP Formula Being Used
Error Did not find value '100103' in VLOOKUP evaluation.
Google Product Forum Post
The user is experiencing a similar problem. They received a solution, but not an explanation of the solution. As a result, I'm not sure how to adjust my formula(s).
Any ideas how to solve this?