I have a list of regions in column D and a list of regions in column A, some regions are present in both lists, some not. I want to transfer the corresponding region values in column B to column E, e.g. look at region in D2, does it appear in list in column A? If so, return corresponding value in column B to E2. Hope someone can help.
Thanks
Matt
Thanks
Matt