defining a cell based on a range

[HarryKlein]

Hello,

I need to make a sheet, where the value of a cell is based on the a from- to value of an other cell.
Eg of the value is 0-10, then the value is "A".
It is a lot of range, nested AND/IF-s would be quite complicated. Does anybody know a good technique for this?

Thanks

[Ace_XL]

Use the lookup formula..an example would be

=LOOKUP(A1,{1,11,21,56,76,89},{"A","B","C","D","E","F"})

The numbers need to be I ascending order and will define the lower limits of your range

[HarryKlein]

I have hlookup and vlookup only. What shall I do?