VLOOKUP -- second instance?

  • Thread starter Thread starter jayhawk1919
  • Start date Start date
J

jayhawk1919

If you're looking up an instance using VLOOKUP, and in the table you
define there are two instances of what you are looking up, is there a
way to tell it to ignore the first and go for the second?
 
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the
following will select the value in the third column of A2:C23
corresponding to the the second occurrence of 7 in the first column.

=INDEX(VLookups(7,A2:C23,3),2)

Alan Beban
 
Back
Top