I found this formula in a spreadsheet:
=VLOOKUP(F12959,lookup!A:B,2,FALSE)
It is not the LOOKUP function nor is it referencing a sheet tab named lookup. When tracing precedents, it is showing lookup!A:B as a table but there are no saved tables named lookup in my spreadsheet and no named ranges but the formula works and I cannot find the source data.
What am I doing wrong?
=VLOOKUP(F12959,lookup!A:B,2,FALSE)
It is not the LOOKUP function nor is it referencing a sheet tab named lookup. When tracing precedents, it is showing lookup!A:B as a table but there are no saved tables named lookup in my spreadsheet and no named ranges but the formula works and I cannot find the source data.
What am I doing wrong?