I have a list of phone numbers. I want to be able to lookup the area code for each row and find the corresponding state. So I use LEFT (3) characters on the phone number field to obtain the area code. Then I perform an XLOOPUP on the area code to find the match in the Area Code table. But it retuns #N/A. Does XLOOKUP work with values that are the result of a text formula? If not, is there another type of lookup that would work in this situation?
I attached an example. Phone numbers are fake. Thanks.
Bookmarks