Hi,

I need to be able to lookup a value in a row based on 2 or more columns. I
need to get the contact name for the Story based on the project name.

The spreadsheet I need to use for the lookups are (based on a pivot table).
Project Name Story Name
T&M_FinanceApps BOS Reports
EBIT Reports Changes

I need to get the contact name from the following.
Name Story Name Display
Name Contact
T&M_FinanceApps Finance T&M
A.Person
T&M_FinanceApps BOS Reports Finance T&M
B.Person
T&M_FinanceApps EBIT Reports Changes Finance T&M C.Person

Any help or ideas would be appreciated.
Thanks