Hello All,
Been looking all over for this answer but am yet to still figure it out.
Since index match only looks at the first match, and if it is blank it will return a 0, how do I get excel to look at the second match which may contain information?
Here is the data I am working with and the...