MIN function problem

Hi,

Anaybody got any idea with this problem that I have?

I'm using MIN function to find smallest number from column C. How can I copy a text from the column A (from the cell in column A) from the same row that the MIN function found??

Your help is much appreciated, thank you!!

KiBBo

Hey,

I am pretty new to this but this might help:

Move the data from column A into column D (so it is to the right of column C).
Then use the formula below to find the lowest value in column C and to pick the matching value from column D to display.

=VLOOKUP(MIN(C2:C27),C2:D27,2,FALSE)

Any good?

Danny

Hello,

U can use vlookup function for the same. Only thing is that u will have shif column 'A' after column 'c'. say now it is in column 'D'. Min value of column is in cell E1. Then in cell F1 enter formula
=vlookup(E1,C1:D100,2)

See if it works

Hi,

Thanks for your replys.

Unfortunately I didn't solved it yet. With DannyG and Vandanavai's functions I got this #NAME? - message. As I described I have TEXT in column A, not numbers...maybe this is the problem?? Any ideas. Thanks.

KiBBo

That shouldn't be a problem. You have to move the data in column A into column D though for it to work

DannyG,
I have done that move or actually I have copied column A data to column D, still I got that #Name? error.
So at the moment my excel sheet looks like this ->

A B C D E
test 6 test #NAME?
test 2 test
test 3 test


and the code in cell E1 is like this -> =VLOOKUP(MIN(C1:C3),C1:D3,2,FALSE)

Whats wrong? (Column B is empty)

No idea what is wrong. That should work perfectly! It does on my spreadsheet.

Maybe try and retype the formula and see if it sorts itself out.

You could also try writing:
=VLOOKUP(2,c1:d3,2,false) as this should give you the answer TEST

Then, if this works replace the 2 with Min(c1:c3).

Other than that I am not sure why it does not work for you.

Quite interesting DannyG...
I've been testing this in my second computer which has Office 2007 and in there it is not working. I moved to another computer which has Excel 2002 (Office XP?) and in there the formula you suggested is working like a dream.