Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How to Create VLookup for a range of specified grades?

LOL!

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Ron Coderre" wrote in message
...
Sorry, I have no idea how that post ended up in this thread.

I'm guessing it's a hardware problem:
A loose nut in front of my keyboard!

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

Try this:

ViewPage Break Preview

For individual manually inserted page breaks:
Drag them off the page

To clear ALL manually inserted page breaks:
Right-click in any cell and select: Reset all page breaks

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Karaoke2lady" wrote:

cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59=
D, 60
to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched
up
with the lowest score possible for that grade. Using the
insert,function,
Vlookup table I can not get what to put in each of the 4 categories
except
for False. Please Help! Thank you.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create a trend formula with range that changes alison Excel Discussion (Misc queries) 0 January 25th 06 10:46 PM
Range Lookup in VLookup ?'s Bronco_Junkie Excel Worksheet Functions 1 November 2nd 05 08:53 AM
How do I create an equivalent VLOOKUP function using FIND? dan Excel Worksheet Functions 8 August 17th 05 04:43 PM
Trying to create formula to give range of stan.deviations of mean Roger Excel Discussion (Misc queries) 5 July 17th 05 06:58 PM
Dynamic Range for Function (Vlookup etc) IshtiaqM Excel Worksheet Functions 4 March 27th 05 09:47 PM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"