I am trying to match customer numbers based off criteria in another cell.
Bill To Customer Number Group
12345 6789 1
12345 9876 2
When I look up the Bill To number I only want the customer number associated with Group 2
I've tried a few things, but I could be way off. Any help is greatly appreciated!!
Thanks!
Bookmarks