I am trying to get the row reference from a vlookup not the value.
A: B
Shop : sales

I have repeating records for 100 shops and I am trying to get the row
reference for the first & last record for each shop so that I can use it in a
TTEST function