Lookup across 2 or more columns to match a row
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 |
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 |
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 |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com