Hi Faraz

Try the below array formula

Lookup value in C1
Lookup array A1:B1000
The last entry denotes the nth entry (in this example it is 2)

=INDEX($B1:$B1000,SMALL(IF($A$1:$A$1000<$C1,"",($ A$1:$A$1000=$C1)*ROW($A$1:$A$1000)),2))

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Any formula or UDF to use VLOOKUP so as to return the nth (for example 6th
entry) feedback when there are more than one matching entries in the lookup
array?
--
Best Regards,

Faraz