VLookup Problem

[Guest]

Hello there,

as I was connecting some databases to get some results I wrote this formula:

=VLOOKUP(A2;'Co-workers'!$A$1:$T$21;(IF(M2=2003;3;(IF(M2=2004;4;(IF(M2=2005;5;(IF(M2=2006;6;(IF(M2=2007;7;(IF(M2=2008;8;(IF(M2=2009;9;10)))))))))))))))*F2

'Co Workers' being a database containing 100 collegues. As it are 100 rows;
from which I allready inserted 16 of them, I altered the formula to:

=VLOOKUP(A2;'Co-workers'!$A$1:$T$100;(IF(M2=2003;3;(IF(M2=2004;4;(IF(M2=2005;5;(IF(M2=2006;6;(IF(M2=2007;7;(IF(M2=2008;8;(IF(M2=2009;9;10)))))))))))))))*F2

I just changed the 21 for 100. Thought it does not work anymore and in all
cases returns the value '0'.

Does anyone know what is worng and can be done? Thanks in advance!

 

[Bob Phillips]

This works for me

=VLOOKUP(A2,'Co-Workers'!$A$1:$T$100,MIN(M2-2000,10),FALSE)*F2

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

So simple... IT'S ABSOLUTELY BRILLIANT!!