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