vlookup

[Russ]

How do you get vlookup to skip the first item found and
pick up the second item?

 

[Jason Morin]

=INDEX(B1:B4,SMALL(IF(G1=A1:A4,ROW(A1:A4)),2))

Array-entered, where:
A1:B4 = lookup table
G1 = lookup value

HTH
Jason
Atlanta, GA

 

[Russ]

Thanks - that did it.

-----Original Message-----
=INDEX(B1:B4,SMALL(IF(G1=A1:A4,ROW(A1:A4)),2))

Array-entered, where:
A1:B4 = lookup table
G1 = lookup value

HTH
Jason
Atlanta, GA

.