Hi,
I am looking for a formula that automatically searches through the bold columns and returns each of the matched values that I need. The first set of data 001-STEN is how I need the formula to operate. My hunch is that its some iteration of an index match formual but I have not been able to...