# EXCEL VLOOK Function

I have been having trouble with this function. Please tell me what I am doing wrong. This is for a grade book.

VLOOKUP(S9,\$S\$14:\$T\$18.2)
S9 is the semester grade, S14-T18 is the table, 2 is the letter grade column.

Posted by on

• Level 1:

An expert who has achieved level 1.

• Contributor

How to creat ms excel vlookup() function?

Posted on Nov 20, 2008

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

Just noticed a small syntax problem, try this:
VLOOKUP(S9,\$S\$14:\$T\$18,2,0)

I always add the last parameter of "0" to insure that that an exact match is found.

Posted on Jul 28, 2008

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### All function that can be used in excel

http://www.xlfdic.com/

Thanks for choosing Fixya.........
Sandeep

Mar 18, 2011 | Excel Function Dictionary

### What is vlook up & what is hlook up?

The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel
http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks
Sandeep

Mar 14, 2011 | Microsoft Excel for PC

### What is the function of Microsoft excel?

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

### RANK FOR PASSING STUDENTS

You will have to use a logic saying If subject1 > 34 and subject2 >34 and subject3 > 34. Idead is to tell the prog that all subjects have to be > 34 by using the AND function. If you use OR function, then the first subject having > 34 will complete the condition and you will get the result, which will be wrong. So, use the AND function. How? Use the help on Using functions in Excel or whatever you are using. They all have it inbuilt.

Aug 22, 2009 | Computers & Internet

### What are uses of vlookup n hlookup?

An implementation of the vlookup in Excel could be:
You have an Excel table with student names and their grades.
You wish that you could somewhere in the sheet type a student name, and immediately retrieve his grade (based on the data in the table).
To achieve this, you can use "Vlookup": the function will look for the student’s name in the first column in the table, and will retrieve the information that is next to his name in the second column (which is his grade).

Hlookup is the same excpet it is for data arranged by rows instead of columns.

Dec 29, 2008 | Microsoft Office Home and Student 2007...

### Student marksheet prepare wtih Ms Excel With following conditions

Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
for Ex:;
here m1,m2,m3 ...are the cells denoting Marks, Totalmark is the cell Showing total marks and Grade is the grade applied for the condition. here also you can use one more if function to find the grade among A,B,C,D,E
First this function check whether any of the given marks are less than 35. if any of the marks is less than 35 it will get the answer TRUE for the OR Function and you will get the Totalmark Cell VAlue, else it will go to Grade Clause.

Dec 06, 2008 | Computers & Internet

My dear user,

Vlook up is asoftware tool in built used to look data simultaneously at a time. However, the situation depends on the data you enter- and look up.For example, if you enter a drug name " cough-act" you can have a look at it by just typing key word only with alphabet.

Sep 12, 2008 | Microsoft Computers & Internet

### Ms excel

Try clicking the down arrow beside the autosum button in your Excel Standard toolbar. Then click More FUNCTIONS. An Insert Function dialog box appears. There use can explore all MS Excel functions.

Oct 10, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

426 people viewed this question

Level 3 Expert

Level 3 Expert