View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOTLITA64 LOTLITA64 is offline
external usenet poster
 
Posts: 2
Default VLOOKUP WITH RANGES

I would like to create a VLookup chart for a range. For example iin cell F5
is 85% and if you go to the VLOOKUP CHART if the amount is between 80% - 89%
than this is returns to F6 the letter B (for a grade B). Can someone help me
with creating this VLOOKUP chart and tell me how to write the formula as well
as set up the VLOOKUP chart?