Question about Match and finding data

"Zargon_osu" wrote in message
...

I have a column with many data values.
I would like to find the row number of the second cell in the list that
exactly matches a given data value. Using the "Match" function with
option match-type = "0" it is easy to find the first cell that matches.
Using options "1" and "-1" doesnt work because those search for
greater than or less than values.

This seems like a simple easy operation, but I can't seem to find a way
to do it without creating more columns of related data or performing
some user intervention. I need the spreadsheet to find the column
number and that number is immediately accessed by other areas of the
spreadsheet.

Any ideas?

Exactly what you need is described here under "Arbitrary Lookups":
http://www.cpearson.com/excel/lookups.htm