Nel post
*motorjobs* ha scritto:

Formulas:
=VLOOKUP(T1,T4:Z29,3,5)
=LOOKUP(T1,T4:T29,V4:V29)

T1=5

Result us "Year 27" (should be Year 19)

[cut]

Try this:

=VLOOKUP(T1,T4:Z29,3,FALSE)


(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy