Question about Match and finding data

  • Thread starter Thread starter Zargon_osu
  • Start date Start date
Z

Zargon_osu

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

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

Any ideas
 
Zargon_osu said:
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?
Click to expand...

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