#### largeselection

##### Active Member

- Joined
- Aug 4, 2008

- Messages
- 353

I'm sure there is a way to do it, but I can't figure out the simplest way short of a really long really nested if function.

I have a list (900 lines long) and then I have another list which corresponds to scores. Here is an example:

100 - A

90 - B

80 - C

70 - D

60 - E

50 - F

40 - G

30 - H

20 - I

10 - J

0 - K

In the real sheet the numbers are one column and then letters are the next column. I also have another list like this:

30

34

35

90

93

40

64

...

Basically i want to put in a formula into the cell next to the first value in the list immediately above so I can drag it down and have it put the corresponding value from the comparison chart (the first example above).

The only way I thought of was to do =if(and([CELL w/ first score]>[lower bound score- 90],[CELL w/ first score]<[upper bound score- 100],[Cell next to upper bound- A],if(and(... and then replace the bounds with the next set so the next upper bound would be the previous lower bound...

but because the list with the bounds is long as well 50 cells, that would be a really long really nested if statement.

There MUST be a more efficient way of doing this.

Thanks!