[Solved] How do I get the row number?

[Ilan]

Suppose I have a list of expenses and I want to get the text defining the maximum expense.
For the sake of argument, the text is in column B and the expense in column D.
To get the maximum I would use =MAX(D1:D100), but I want to know what row that is.
If I knew the row I could put in column G1 =B10, where B10 would be some sort of variable.

This should be a simple question to someone with more experience than myself.

Thanks,
Ilan

[Villeroy]

Get the text in B from the row where max(D) is found:
=INDEX($B$1:$B$100;MATCH(MAX($D$1:$D$100);$D$1:$D$100;0))

MATCH returns an integer number>0 indicating the matched position (or #NA in case of no match).
INDEX returns a value out of a range, specified by the row index and (optional) column index.