Hello everyone!
I’m trying to create a formula so I can incorporate at this macro I’m working on. I need a “different” VLOOKUP. This excel file contains two worksheets, the first one is “August” and the other one is the “Control Number Table”.
August - Contains a list of Customer Numbers.
Control Number Table - Shows all control numbers available for Costumer Numbers.
Each Customer Number has a Agency Code and Cost Center. The condition for this VLOOKUP is:
If Customer Number, Agency Code and Cost Center repeat I need the same control number. But sometimes the same Customer Number comes with different Agency Code and Cost Center, in this case I need the next Control Number available (please see the example on excel file attached so you can understand better).
Any ideas?
Bookmarks