How to return row number

[wrhopcraft]

On Sheet 2, I have an array. There is a drop down list on Sheet 1 that has all of the values from the first column of the array. In another cell on Sheet 1, I would like to display the row number of the array that corresponds to whatever value is selected from the drop down list. How can I do this?

[Richard Buttrey]

By array I assume you mean a range of values.

One way

MATCH(A1,Sheet2!A:A,FALSE)
where A1 contains the dropdown result

Regards

[wrhopcraft]

Perfect! Thanks very much!