One way:

=INDEX(B1:B11,SMALL(IF(A1:A11=F3,ROW(A1:A11)-MIN(ROW
(A1:A11))+1),X))

Array-entered (press ctrl + shift + enter), whe

B1:B11 = range that contains the value to return
A1:A11 = range that contains the value to look up
F3 = holds the value to lookup
X = nth instance to look up

So, for example, this would find the 3rd instance of the
value in F3 in A1:A11, and return the corresponding value
in B1:B11:

=INDEX(B1:B11,SMALL(IF(A1:A11=F3,ROW(A1:A11)-MIN(ROW
(A1:A11))+1),3))

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

Could anyone help me...

When I enter a vlookup formula, the first matching value
is found and
displayed, is there any way of getting the formula to
look up the second or
third values, e.g. to look at a trend over a particular
week. I have been
able to do this before somehow using these symbols {}
but cannot remember
what I done!
Thanks for any suggestions,

Willie
.