Less i column

[Guest]

Hello from Steved

=IF(ISNA(VLOOKUP(D6,$S$2:$W$2000,5,FALSE)),"",VLOOKUP(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.

 

[Sandy Mann]

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,MATCH(D6,R1:R2000,FALSE)))


--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Guest]

Thankyou Sandy

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,MATCH(D6,R1:R2000,FALSE)))


--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk