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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I record new Highest / Lowest numbers as data changes in ce 2
Showing the top result from a range of cells 6
Pick the low number in a column of Numbers 3
Index / Match / value in a range? 2
Function to put worksheet name in cell returns text, need number 5
Convert text to numeric value 1
Excel Need Countifs Formula Help 0
problems getting this macro to work 23

Back
Top