Hello from Steved

=IF(ISNA(VLOOKUP(D6,$S$2:$W$2000,5,FALSE)),"",VLOO KUP(D6,$S$2:$W$2000,5,FALSE))

Ok the above is fine it picks up the 5th column Col W
Question is it possile to lookup the column to the left ie -1
=IF(ISNA(VLOOKUP(D6,$R$2:$V$2000,-1,FALSE)),"",VLOOKUP(D6,$R$2:$V$2000,-1,FALSE))

Thankyou.