Hi,

I'm doing a Vlookup match function and it works, but what I want to do is
get the second match of a value.

eg:
..............1st.....2nd......3rd........4th..... ..
meat....good.....bad.....ok..........good....
chicken.OK......good......bad.......ok.....
fish......good....bad......bad.......ok......
meat....OK....good...good.......good....

B12=meat
B13= 2nd

my formula looks something like this:
VLOOKUP(B12,A1:AF10, MATCH(B13,B1:AF1,0)+1 ,FALSE)

what it does is get me the first row meat, 2nd column (bad) but what I want
is second row meat, 2nd column (good). how do I ammend the formula
accordingly.

Thanks!