Solved: Row After Vlookup

[wadirks]

I want to know the row() where the results of a vlookup() were found. Preferably without using a macro. Something like: =ROW(VLOOKUP(NamedCell,NamedRange,1,FALSE)), which of course does not work. Your suggestions would be appreciated.

[mikerickson]

The Match function

=MATCH(NamedCell,NamedRange,0) + ROW(NamedRange) -1

[wadirks]

Exactly what I needed. Thank you.