painfully_average
New Member
- Joined
- Mar 11, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Through VBA, I was able to take unpivot my horizontal data table and get each name/ID # on it's own line. I am not needing to parse through the data and return values based on the Name, ID #, and Visit #.
Basically names are visited between 1 and 3 times checking for malfunction. If there is a malfunction, it is visited a second time for repair, and a third time if that repair fails. Pictures are taken at each visit, so a single component may have three sets of picture #s.
I think the best way to do this will be through an Index/Match to check for the three criteria and return the cell that matches, but I'm having difficulty getting started. I'm working primarily with cells E20:H23.
Basically names are visited between 1 and 3 times checking for malfunction. If there is a malfunction, it is visited a second time for repair, and a third time if that repair fails. Pictures are taken at each visit, so a single component may have three sets of picture #s.
I think the best way to do this will be through an Index/Match to check for the three criteria and return the cell that matches, but I'm having difficulty getting started. I'm working primarily with cells E20:H23.