View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.?