Reference to Row number

[Saturn]

I want to have the row number which refers to input in a cell and a list.
How do I write the forumla?
Please see the attached file which expain it better.

[udprocks]

Hi saturn,

Something like this?

please see the file.

[Punnam]

Hi,
Try this

=MATCH(F4,$C$1:$C$500,0)

Punnam

[Saturn]

Thanks to both of you.
udprocks: I cant use your sugestion because I want the 'adress' or reference to the actual worksheet row. But thanks anyway.
Punnam: this works! Thanks.

[Punnam]

hi Satutn,

Thanks for the feedback

Punnam