how to use vlookup in excel to display letter grades

HOW TO USE VLOOKUP IN EXCEL TO DISPLAY LETTER GRADES HOW TO

Be careful to not type in the letter of the column of the spreadsheet or the syntax would be incorrect. For example, if you have columns that run left to right reading “First name” “Last name,” and “Age”, and are looking for information in the “Age” column, you would type “3” as your col_index_num. This number indicates the column in the table that you want to extract information from. For example, if you want to look at another file named “MyBusiness” for Profits sheet and the A2 to C15 table, your table_array will look like Profits!$A$2:$C$15. To pull in information from a different Excel document, you would have to put the file name with Excel file extension in square brackets. For example, if your data spans A2 to C15 in the sheet titled “Profits” then you would input your table_array as Profits!$A$2:$C$15. To input table_array from tables in a different sheet, you would have to input the name of the sheet exactly followed by an ! symbol. For example, if your table name is “2021SpringData”, then your table_array is 2021SpringData. Make sure to type the name of the table perfectly and keep it out of quotation marks. You could also input the range as the table name, if your table has one. For example, “locking” A2:C15 would look like $A$2:$C$15. To “lock” your cell range, you add the $ symbol in between the column letter and the row number. If you want to copy your VLOOKUP formula and paste it into another cell, then it is recommended that you “lock” your range so the formula isn’t confused on where to look. For example, if your data begins in the cell A2 and ends the cell C15, then you would enter your table_array as A2:C15. You input the array in for the format of cells separated by a colon. This range should include the column you inputted as your lookup_value and exclude the row of column names. That would be followed by the bottom rightmost cell of the table. This way, you would input the upper leftmost cell in your table you want VLOOKUP to search. The first way to input table_array is by cell. You also have the ability to even lookup tables in different sheets or documents. You can input the table_array in two main ways. Usually, it’s the data table you’re looking at. The table_array is how you determine the range you want VLOOKUP to search for your desired information. The lookup_value is usually located in the leftmost column of the table. Keep in mind that when you put in your look_up value that VLOOKUP will only search columns to the right of that cell. Finally, the lookup_value can also be a number, such as 0.7. In this case, it would have to be inputted with quotation marks such as “Apples” or “John Doe”. The lookup_value could also be a specific word or phrase. It can reference another cell that has the determined value in it, in which case you would input the cell in question, such as A5, or click on the cell A5.

There are many ways the lookup_value can be inputted into the function. Let’s break down what each of the parts means.

=VLOOKUP (lookup_value, table_array, col_index_num, )

HOW TO USE VLOOKUP IN EXCEL TO DISPLAY LETTER GRADES HOW TO

Before learning how to use the function, we need to know the different arguments, or parts, of the VLOOKUP syntax.

How to use vlookup in excel to display letter grades