Good afternoon all, sorry for whats probably a newbie question...
I'm trying to put together a formula that reads if a cell A1 is between a certain range it displays a grade in cell B1 and so forth.. Please see the attached sheet. Can anyone help? I tried using IF but as soon as i exceed 7 statements it's game over.
thanks very much
Ryan
Move your column D over to E and change the "upto" to 0. Then in B2
=VLOOKUP(A2,$E$2:$F$22,2)
Does that work for you? It looks for the value in A2 in E2:E22 and finds the value without going over and returns the 2nd column (col F).
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi, thanks for the quick response.
I just want to say...you are an evil genius.. works perfectly!!
Thanks very much. i have spent hours looking at this.
Thanks again. rep up +1
Last edited by ryanwalton; 09-24-2010 at 09:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks