I need a formula to find the range of matching values in a column. I can use MATCH to find the first matching value, but am having difficulty finding the last matching value. I am trying to create a dynamic range for subsequent vlookups.
Solved by I. H. in 30 mins