Hi, I have attached an image for what I am looking for, along with a sample xls. Basically I have two sets of data where one set has extended information that I need to pull into the other to add more context. So, I need to compare what is in column a1 and find a match in a different column, and then take one of the bits of data from that row. Please see the picture as it may be harder to explain than show.
Thanks for any help in sharing the formula to do this.
Bookmarks