Forgot to mention that this is an array formula, so commit with
Ctrl-Shift-Enter.
--
HTH
Bob Phillips
"Bob Phillips" wrote in message
...
Something like
=INDEX(Data!E1:E1000,MATCH(A2&B2,Data!A1:A1000&Dat a!B1:B1000,0))
where Data is the sheet with the table, the lookup values are in A and B
respectively, and the contact is in E.
--
HTH
Bob Phillips
"Cara" wrote in message
...
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
|