Good day all.
I am having some difficulties with a formula. I have several tabs containing maintenace data for company vehicles. On the first Tab, I have a summation area.
I have several variables I would like to pull, like most/least mileage, highest/lowest repair bills etc. I have used MAX/Min no problem to get the data. My question is that in the next field I want to pull in the Van # beside the entry. Ie. Most mileage - Results - Van #. Is there any way to grab the offset of the MAX/MIN results to determine the appropriate VAN #? Is there some function/way to grab the variable?
FYI Van name for each sheet is at A1 and as the Tab name (ie Van 1, Van 2, etc).
Your thoughts please.