VLOOKUP #NoMatch has me completely stumped

Liz Castellaw
Liz Castellaw ✭✭
edited 06/14/22 in Add Ons and Integrations

I have a vlookup formula in my sheet (Project Plan) that references another sheet (Phone List). Despite triple checking formulas, spelling, spaces, etc. I could not get the formula to return anything by #No Match. I copied and pasted the original sheet (Phone List) that's referenced into a new sheet (Copy of Phone List) and now the formula works. I really don't want to have two separate sheets with the exact same information. Please help me figure out why the formula in Project Plan doesn't work when I reference Phone List! Thank you! (The only thing I can think of is I only have View permission on the original phone list.)