Greetings,
Not sure if Index/Match would be the best for what I'm trying to accomplish, but I would be grateful for any solutions to this problem. I'm trying to compare a set of account numbers in column A, with a long list of account numbers in column b and if a match is located it will produce a result of pulling data in column E in the same row that the match was located from column b. Column A may have duplicate account numbers too, but if that happens it would just need to produce the same match results, etc. I tried searching this site and online, but couldn't quite find anything that worked. Really appreciate your time. A sample workbook is attached.
Bookmarks