Hello,

If I have an Excel 2007 spreadsheet containing a column of numbers which are
sorted according to magnitude. I want to determine which row a specified
value occurs in, how do I do this? The value to be found is contained in a
user-entry cell and is a Named variable. Is there a way to do this with the
ROW function? If I for example assign the value the Name of "Sales" and refer
to the cell where it is stored, how do I seek that value in my column of data
and report the row number in which it occurs?

Thanks,
Harold