how do i bring over text and number t

  • Thread starter Thread starter jule_29
  • Start date Start date
J

jule_29

I need help......I will give you an example.....say I have a name and
numerical value in F1-F4.......I would like to know the formula that I
could put in A1 that would not only pick out the lowest numerical
value, but bring that lowest value and name to cell A1.
Any help is GREATLY appreciated.
 
Hi
not sure where your name is, but if your name is stored in column G try
=INDEX(G1:G4,MATCH(MIN(F1:F4),F1:F4,0))

Frank
 
Back
Top