| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple criteria for lookup table
I am currently using VLOOKUP to grab values. I now realize that there are
multiple criteria involved before a decision can be made. My data looks like this: New Role Name BU Region Recommended Role Owners 50003281 Service North America Marnie Perez/Wendy Synol/Jackie Howson 50003281 Service EMEA Francis Hopwood/Jackie Howson 50003281 Service Asia Pacific Andy McDougall/Wendy Synol/Jackie Howson 50003281 All North America Cathy Parker 50003281 All EMEA Guido Moresi/Stephen Lovass/Axel Terlinden 50003281 All Asia Pacific Guido Moresi/Stephen Lovass/Axel Terlinden My lookup is using Role Name but I also need to consider BU and Region before I can grab Recommended Role Owners. Any solutions I hope? This is my current formla: =IF(ISNA(VLOOKUP(B14,'All Roles'!$A$1:$F$3485,6,FALSE)),"",VLOOKUP(B14,'All Roles'!$A$1:$F$3485,6,FALSE)) Thank you in advance for your assistance. Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum column information based on multiple criteria | Excel Worksheet Functions | |||
| Counting total for multiple criteria | Excel Worksheet Functions | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| counting using multiple criteria | Excel Discussion (Misc queries) | |||
| Select by multiple criteria (Excel 2003) | Excel Worksheet Functions | |||
Threaded Mode
