Lookup the 3rd Value
 

Any formula for an Index/Lookup formula to return a specific entry?

For instance, I want the corresponding entry in column B against the third
or fourth entry in Column A representing the entry "Customer A"?

Thanx in advance.
--
Best Regards,

Faraz

Lookup the 3rd Value
 

C1 = 'Customer A'
C2 = nth lookup 1,2,3 etc;

Try the below array formula
=INDEX(B1:B50,SMALL(IF(A1:A50=C1,ROW(A1:A50)),C2))

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


"Faraz A. Qureshi" wrote:

Any formula for an Index/Lookup formula to return a specific entry?

For instance, I want the corresponding entry in column B against the third
or fourth entry in Column A representing the entry "Customer A"?

Thanx in advance.
--
Best Regards,

Faraz