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

sorry on ; use comma ,

language mistake, my excle is in Brazilian Portuguese


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

=LOOKUP(H6;{0;0,1;0,2;0,3;0,4;0,05;0,6;0,7;0,8;0,9 ;1};{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K"})

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"LOTLITA64" escreveu:

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?