Jamie Wagler
Member
Please refer to the attached file.
What I am trying to do is populate Column I in the first tab with the latest date for each part from Tab 2. Column O has the count per part from the second tab. I cannot use a Vlookup as it will only capture the date of the first occurrence of the part#.
As I
Tab 2 will be a growing list going forward so there will be multiple entries per part.
Also the entire list of parts is more than 9000, this is just a sample.
I was trying an
=IF(O2>0,INDEX( Tab 2 MATCH( Part # Tab 1),LARGE( Date Tab 2)),0)
but I could not get it to work.
Your assistance is appreciated!
What I am trying to do is populate Column I in the first tab with the latest date for each part from Tab 2. Column O has the count per part from the second tab. I cannot use a Vlookup as it will only capture the date of the first occurrence of the part#.
As I
Tab 2 will be a growing list going forward so there will be multiple entries per part.
Also the entire list of parts is more than 9000, this is just a sample.
I was trying an
=IF(O2>0,INDEX( Tab 2 MATCH( Part # Tab 1),LARGE( Date Tab 2)),0)
but I could not get it to work.
Your assistance is appreciated!
