VLOOKUP -- second instance?

[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?

 

[drabbacs]

See this site for Arbitrary lookups, about 1/2way down the
page

http://www.cpearson.com/excel/lookups.htm

 

[J.E. McGimpsey]

Look at Chip Pearson's explanation under "Arbitrary Lookups":

http://www.cpearson.com/excel/lookups.htm

 

[Alan Beban]

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