I have a worksheet with a column containing names of Provinces and a column with its corresponding Region. On a separate worksheet I have an Address column. What I want to do is to find the Province in the given Address, then ultimately finding out what the corresponding region is.
Client | Address | Region Tony | 5th Avenue, Manila | ??? Grace | Mactan, Cebu | ???
Region | Province NCR | Caloocan NCR | Manila Visayas | Bohol Visayas | Cebu
I need to look for the values in the Province column on Sheet2 within the Address cell, i.e., search for "Caloocan" "Manila" etc. in "5th Avenue Manila", and when found - return the Region, i.e., NCR. Such that the end product is the following:
Client | Address | Region Tony | 5th Avenue, Manila | NCR Grace | Mactan, Cebu | Visayas
Any input would be awesome. Thanks.