elizabethCat
New Member
- Joined
- Jan 25, 2019
- Messages
- 1
I am trying to do an index match. I want to match the Vendor ID and Max Manual Date in the Audit tab to the corresponding row in the Quality tab to get the Manual Rating and then to match the Vendor ID and Max of EtQ Audit Date to get the EtQ Rating. None of my formulas work. Can someone point me in the right direction? I'm tried several formulas on-line and I'm getting nowhere. Thank you!
Audit Tab
<tbody>
</tbody>
Quality Tab
<tbody>
</tbody>
Audit Tab
<tbody> </tbody> | Max Manual Audit Date | Max of EtQ Audit Date |
<tbody> </tbody> |
<tbody> </tbody> | |||
2900000909 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Quality Tab
Vendor ID | Manual Date | EtQ Date | Manual Rating | EtQ Rating | |||
2900000909 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 0 | |||
<tbody>
</tbody>