how do i bring over text and number t

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.
 
F

Frank Kabel

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
 
Top