kellykivisto
New Member
- Joined
- Oct 30, 2008
- Messages
- 5
I want to match the (Sheet1) clent /group to the (LookupTable)name /group and return the corresponding retention.
Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name??
=IF(ISNA(MATCH(A2&"/"&B2,LookupTable!A:A&"/"&LookupTable!B:B,0)),"",VLOOKUP(A2,LookupTable!$A$2:$H$100000,3,FALSE))
Problem:
It is only matching and inserting the first instance of the Retention when there are 3 possible answers.
<tbody>
</tbody>
<tbody>
</tbody>
Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name??
=IF(ISNA(MATCH(A2&"/"&B2,LookupTable!A:A&"/"&LookupTable!B:B,0)),"",VLOOKUP(A2,LookupTable!$A$2:$H$100000,3,FALSE))
Problem:
It is only matching and inserting the first instance of the Retention when there are 3 possible answers.
Client | Group | Retention Policy |
potato | Ntwrkr_Daily 4 - 12:00 AM | Year |
potato | NetworkDaily-6AM | Year |
potato | Ntwrkr_Daily 4 - 12:00 AM | Year |
<tbody>
</tbody>
Name | Group | Retention Policy |
potato | Ntwrkr_Daily 4 - 12:00 AM | Year |
potato | NetworkDaily-6AM | 7 Years |
potato | Ntwrkr_Daily 4 - 12:00 AM | Month |
<tbody>
</tbody>