Hi, I have a problem to generate a ZIP code from a given address. I tried Index+match and If+iserror+search but I cannot because the address is too long and the reference is shorter.
I have attached a sample file on it.
thanks in advanced.
Hi, I have a problem to generate a ZIP code from a given address. I tried Index+match and If+iserror+search but I cannot because the address is too long and the reference is shorter.
I have attached a sample file on it.
thanks in advanced.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks