×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Reference cell next to min..(Lookup?)

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

RE: Reference cell next to min..(Lookup?)

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/
 

RE: Reference cell next to min..(Lookup?)

(OP)
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

RE: Reference cell next to min..(Lookup?)

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/
 

RE: Reference cell next to min..(Lookup?)

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources