Here is what I am trying to do I have 4 columns A which displays names; B which displays a corresponding id number to the name in A. I also have column D which has more id numbers and column E which has email addresses that correspond with the ID numbers in column D. I do not have email addresses for each id number so there are less values in columns D&C than A&B. What I want to do is match the ID number In B With the ID# D and display the corresponding email address from column E in column C.
Seems simple enough but I have tried a hundred things and cant get it to work. looking fro a fresh start, any help is appreciated. Thanks
Bookmarks