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.

Steved,

If you want the column to the left of your table then you ar not using the
table at all. VLOOKUP looks down the Column $R$2:R2000 to find a match so
use INDEX/MATCH


=IF(ISNA(MATCH(D6,R1:R2000,0)),"",INDEX(Q1:Q2000,M ATCH(D6,R1:R2000,FALSE)))


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Steved" wrote in message
...
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.

Thankyou Sandy

"Sandy Mann" wrote:

Steved,

If you want the column to the left of your table then you ar not using the
table at all. VLOOKUP looks down the Column $R$2:R2000 to find a match so
use INDEX/MATCH


=IF(ISNA(MATCH(D6,R1:R2000,0)),"",INDEX(Q1:Q2000,M ATCH(D6,R1:R2000,FALSE)))


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Steved" wrote in message
...
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.