How can I find the index of a row for a value in excel É <p>is there a function in excel which can find the index of the row for a particular value É </p> <p>ie if I write function(5.77) it will return 5 , because 5.77 appears in row 5 . </p> <p>'1 Frequency '2 4.14 '3 4.19 '4 5.17 '5 5.77 '6 6.39</p>