Maybe I'm trying to solve an unsolvable problem, but I'll ask anyways.
I trying to locate a value within a range, and when the value is found, input a value (total of 10 different values) found from another table. (i.e. If A1:D1 contains one of 10 Manager's Name, then input applicable Area/Line of Business). I hope that wasn't too confusing
Bookmarks