Question
May 4, 2007 at 02:45 PM
cr8success

Excel Lookup

by cr8success . Updated 19 years, 5 months ago

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!

This discussion is locked

All Comments