Ok, so you want to return the value from column B that corresponds to the
2nd instance of "%,VGP" in column A *and* there are only 2 instances of
"%,VGP" in column A...

=LOOKUP(2,1/(A2:A100="%,VGP"),B2:B100)

--
Biff
Microsoft Excel MVP


"dannyboy8" wrote in message
...
OK, in column A there is 1 particular identifier that is used 2 times
(%,VGP
is the identifier) for different sources of income in column B, and I need
to
return only the second instance of "%,VGP". There are no other unique
identifiers to work with in this case.

"T. Valko" wrote:

No.

It can be done with other formulas but you need to give us the details.

--
Biff
Microsoft Excel MVP


"dannyboy8" wrote in message
...
Is there a way to use vlookup to return the instance value beyond the
1st
instance in the array?