=vlookup(j2,A1:B21,2,False)

Use Data Validation and use a custom function

=And(J2=100,J2<=2000,Mod(J2,100)=0)

--
Regards,
Tom Ogilvy

"Michele" wrote in message
...
Hi Guys
B1:F1 are numbers 1-5. A1:A21 are numbers 100,200,300...2000. J1= a number
1-5, say 3 for example. J2 is a number 100-2000, say 300 for example. What
formula would I use in J3 to return the value of D4 (4th column, 4th row)?
Also, what type of validation would I use in J2 to only allow a value
between 100 and 2000 multiples of 100?
Thanks to all