Return the Row number
 

hi, I have got some questions.

I have a table, I want to get the minimum value of a particular row.
I try to do as this
=vlookup(My value, The table, *******)

******* should be the column that shows the minimum value of "My value"

How can i call that column out.?
Thanks.
Kenneth

Return the Row number
 

One guess, maybe you meant something like this:
=VLOOKUP(MIN(A:A),A:D,MATCH(MIN(A:A),A1:D1,0),0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Kenneth" wrote:
I have a table, I want to get the minimum value of a particular row.
I try to do as this
=vlookup(My value, The table, *******)

******* should be the column that shows the minimum value of "My value"

How can i call that column out.?

Return the Row number
 

Maybe I give you my example ...

Node 0 1 2 3
0 0 4 5 6
1 2 0 4 6
2 3 5 0 6
3 2 1 4 0

I will start from Node 0 .
I wish to get the value of node 1 ,
then node 0 will be delete, and node 2 is then found.

"Max" wrote:

One guess, maybe you meant something like this:
=VLOOKUP(MIN(A:A),A:D,MATCH(MIN(A:A),A1:D1,0),0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Kenneth" wrote:
I have a table, I want to get the minimum value of a particular row.
I try to do as this
=vlookup(My value, The table, *******)

******* should be the column that shows the minimum value of "My value"

How can i call that column out.?

Return the Row number
 

Guess I'm out of ideas here for you, sorry. If your intents involve
"deleting" stuff along the way, then a formulas solution is out. Formulas
cannot delete stuff, they can only return calculated values in the very
cells that they are placed in. Try posting afresh in excel.programming
newsgroup, and provide more elaboration in your example. Good luck.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"Kenneth" wrote in message
...
Maybe I give you my example ...

Node 0 1 2 3
0 0 4 5 6
1 2 0 4 6
2 3 5 0 6
3 2 1 4 0

I will start from Node 0 .
I wish to get the value of node 1 ,
then node 0 will be delete, and node 2 is then found.