Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF with two sets of criteria | Excel Discussion (Misc queries) | |||
VLOOKUP in large Data sets of more than 16384 rows | Excel Worksheet Functions | |||
for SUMIF function, how do I use 2 sets of range & criteria | Excel Worksheet Functions | |||
Count rows that match 3 sets of criteria? | Excel Worksheet Functions | |||
Using Vlookup to look at different names sets of data.... | Excel Worksheet Functions |