Reference cell next to min..(Lookup?)
Reference cell next to min..(Lookup?)
(OP)
I was wondering if anyone could tell me a formula that finds the minimum number in a row and returns the contents of the cell next to it. Finding the min is easy enough but I'm not sure of the rest.
Thanks in advance,
Doug
Thanks in advance,
Doug





RE: Reference cell next to min..(Lookup?)
RE: Reference cell next to min..(Lookup?)
Find the location of that value with =MATCH(value,range,0)
Find the value in the next cell with =INDEX(range, location +1)
It's easiest to do using three separate formulas, but you can combine them all into one if you want:
=INDEX(C1:G1,MATCH(MIN(C1:G1),C1:G1,0)+1)
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Reference cell next to min..(Lookup?)
Looks like that's the ticket. I don't spend a bunch of time on spreadsheets very often so when I do I either don't know the formula I'm looking for or I've simply forgotten it! Usually trial and error prevails but not this time.
Thanks again
RE: Reference cell next to min..(Lookup?)
http://of
RE: Reference cell next to min..(Lookup?)
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Reference cell next to min..(Lookup?)