L
laf2day
I'm trying to do a vlookup with 2 sets of criteria. For example: I want to
look up a customer region ( North, South, Central, West) in column A and the
customer number in column D, if they both match then bring back the sales $
in column F.
My issue is that the customer numbers sell into multiple regions across the
country so they are listed multiple times down the column and there are
clearly multiple customer numbers under each region.
Thank you for your help!!!
David
look up a customer region ( North, South, Central, West) in column A and the
customer number in column D, if they both match then bring back the sales $
in column F.
My issue is that the customer numbers sell into multiple regions across the
country so they are listed multiple times down the column and there are
clearly multiple customer numbers under each region.
Thank you for your help!!!
David