I need to find the STATE that any area code belongs to. I have 2 Worksheets 1 – Area Code = Column 1, State = Column 2 2 – Phone Numbers – =left(B1,3) to get the area code. I want to find the STATE that belongs the Trimmed number.
Thanks!