How do you get vlookup to skip the first item found and pick up the second item?
R Russ May 25, 2004 #1 How do you get vlookup to skip the first item found and pick up the second item?
J Jason Morin May 25, 2004 #2 =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
=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
R Russ May 25, 2004 #3 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 . Click to expand...
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 . Click to expand...
