Reference cell next to min..(Lookup?) 1

[4thorns]

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

 

[MintJulep]

Some variation on this thread770-281804

 

[IDS]

Find the minimum with =MIN(range)
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/

 

[4thorns]

Thanks Doug,
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

 

[kacarrol]

You could also use vlookup

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

 

[IDS]

Vlookup would work for numbers in a column and you wanted the value in the cell to the right, or Hlookup for numbers in a row and you wanted the value below, but for the question as stated I don't think Vlookup or Hlookup will work.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[kacarrol]

Oops, my bad I read that over once and in my mind it said find the min number in a column.