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