Hi,

In this sample formula you are looking for a value (E1) in column A and
returning the corresponding value in column B. F1 should hold the occurrence
so a 3 in F1 returns the 3rd occurrence

=INDEX(B1:B13,LARGE((A1:A13=E1)*ROW(A1:A13),COUNTI F(A1:A13,E1)+1-F1))


This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike
"dannyboy8" wrote:

Is there a way to use vlookup to return the instance value beyond the 1st
instance in the array?