I've attached the file. Basically I have a "master" list of items and their count. I then have a second list compiled that is an abbreviation of the first. I would like to apply the count for the second list as well, without having to use the Find feature. All words in the second list are in the first list, but not vice-versa.
What I need is a formula that will look through the range in Column A, and if the word in Column F matches a word in Column A, the corresponding number in Column B is entered.
Does that make sense?
Bookmarks