Vertical and Horizontal Lookup Using Match And Index Function

[sarah]

Hi All

I'm struggling with this excel formula.. I have two sheets and trying to extract the result in Column D in sheet 1 based on the choices made in Columns B & C drop down lists (Username and Status).. I've attached my file.. For example when I select "al2" in Column B and "Days Since Change" in Column C I would get "20".. I wasn't able to make this happen and get the result I want in Column D

Any help is greatly appreciated.. I've attached my file
1066


Thanks

[Excel Fox]

Sheet1!D2=INDEX(Sheet2!$C$2:$E$8,MATCH(Sheet1!B2,S heet2!$B$2:$B$8,0),MATCH(Sheet1!C2,Sheet2!$C$1:$E$ 1,0))

and drag down

[sarah]

you're the best!! thanks for resolving my 10+ hours of pain, you made my day :)