The problem is the range for testing against the Global Delivery Lead, it
spans 4 columns, it should be H6:H40 or K6:K40

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"hoosier41" wrote in message
...
Hi,

I'm wondering if anyone can help me figure out what I have wrong in the
following formula? I am trying to search one worksheet for the rows that
meet these three criteria: SDS PM, Global Delivery Lead and 6, and return
the
name of the event(located in G6:g40) associated with that row to another
worksheet in the same workbook.

=INDEX('Master Com Plan'!G6:G40,MATCH(1,('Master Com Plan'!A6:A40="SDS
PM")*('Master Com Plan'!H6:K40="Global Delivery Lead")*('Master Com
Plan'!Q6:Q40=6),0))