jislandhopper
Board Regular
- Joined
- Jul 23, 2013
- Messages
- 92
Afternoon Everyone,
I hope someone can assist with a small problem. I want to get a formula which searches 2 criteria and return a answer. It's like a Vlookup but with an additional criteria. I've tried consolidating the cells but someone told me that using INDEX and MATCH are a better was to do this. I've tried writing the formula but it doesn't seem to work, so I'm hoping the community can help me out.
I've created a simplified reference table and a small table as example as what I'm after in return. The reference table is where I pull the information from and I want the formula to review Column A and B from the reference data and return an answer on. Column D on the results table. I've added in the reference numbers which I added manually. Can anyone point me in the right direction?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks,
Jason
I hope someone can assist with a small problem. I want to get a formula which searches 2 criteria and return a answer. It's like a Vlookup but with an additional criteria. I've tried consolidating the cells but someone told me that using INDEX and MATCH are a better was to do this. I've tried writing the formula but it doesn't seem to work, so I'm hoping the community can help me out.
I've created a simplified reference table and a small table as example as what I'm after in return. The reference table is where I pull the information from and I want the formula to review Column A and B from the reference data and return an answer on. Column D on the results table. I've added in the reference numbers which I added manually. Can anyone point me in the right direction?
Reference table | ||
Col A | Col B | Col C |
Depo 1 | 06/08/2019 | REF 123 |
Depo 1 | 07/08/2019 | REF 124 |
Depo 1 | 08/08/2019 | REF 125 |
Depo 1 | 09/08/2019 | REF 126 |
Depo 1 | 10/08/2019 | REF 127 |
Depo 1 | 11/08/2019 | REF 128 |
Depo 1 | 12/08/2019 | REF 129 |
Depo 1 | 13/08/2019 | REF 130 |
Depo 1 | 14/08/2019 | REF 131 |
Depo 2 | 15/08/2019 | REF 132 |
Depo 2 | 16/08/2019 | REF 133 |
Depo 2 | 17/08/2019 | REF 134 |
Depo 2 | 18/08/2019 | REF 135 |
Depo 2 | 19/08/2019 | REF 136 |
Results Table | ||
Col A | Col B | Col D |
DEPO | Date from | Ref number |
Depo 1 | 13/08/2019 | REF 130 |
Depo 1 | 08/08/2019 | REF 125 |
Depo 2 | 22/08/2019 | REF 139 |
Depo 2 | 19/08/2019 | REF 136 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks,
Jason