Help with a formula please.

[John Gill]

I'm using an IF statement eg =IF(A20<1000,10,IF(A20<10000,20)),
within the list of the numbers 1 - 10000, certain numbers within the range, for which I have a list, I would like defaulted to say 50.

I dont know if a vlookup table, can be embedded within my current formula, or if there is another formula that will provide me with the answer.

Kind Regards

 

[PaddyD]

in general:

set up a lookup table such that the left hand column has the lowest value for each class, and the right hand column the value to return for the class, then use a formula of the form:

=vlookup(item,lookup_table,2)