=INDEX('All Roles'!$F$1:$F$3485,MATCH(1,('All Roles'!$A$1:$A$3485=B14)*('All
Roles'!$B$1:$B$3485=C14)*('All Roles'!$C$1:$C$3485=D14),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Mark" wrote in message
. net...
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