Posted: 5/25/2017 3:17:14 PM EDT
|
I have a table which lists approximately 1000 different vehicles and the years in which they are projected to be rebuilt, much like table 1 below. The X depicts the year in which each chassis will be rebuilt.
I am trying to summarize this table so that I have two columns like table 2. What formula can I place in cells B9 through B13 to automatically lookup in table 1 when the rebuild will happen return only the year? 
|
