Need help with function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a table showing a range of numbers (column A = from column B = to) and column C is a letter. I want to be able to use a formula so that if a result is between column A and column B it will give me the letter in column C

From To Grad
90.0 100.0 A
85.0 89.0
80.0 84.0 A-.... and so on...

Thank you for any help
 
Hi Isabelle!

Use VLOOKUP

I've set up a table in D1:E15 as follows:

20 E-
25 E
30 E+
35 D-
40 D
45 D+
50 C-
55 C
60 C+
65 B-
70 B
75 B+
80 A-
85 A
90 A+


Now I can use the formula:

=VLOOKUP(A1,$D$1:$E$15,2)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top