View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default VLOOKUP to find a value that falls between a range?

Hi, How do you format a VLOOKUP to lookup something like a student's grade.
Next to each score I want a use VLOOKUP to return "A", "B", "C" etc.

Scores
--------
92
73
87
89
etc.


Lookup Table
---------------
100 90 A
89 80 B
79 70 C
69 60 D
59 50 F