I have 1300 sheets and one sheet with phone numbers in the B column on sheet7
In B1of all the sheets i have a phone number
and B2 i have the name
I want to return the name for all phone numbers on sheet 7.
I have used both formulas above and they work but only when referencing one sheet.