How To Use VLOOKUP In Excel

13

VLOOKUP stands for 'Vertical Lookup'. It is a function that makes Excel search for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row. Its is a very important function in Excel for everyone to know especially for those that need to find information in a large spreadsheet, or you are always looking for the same kind of information, use the VLOOKUP function.If you find yourself repeatedly consulting the same table to find data, however, have a gander at VLOOKUP. Short for "vertical lookup," VLOOKUP takes advantage of vertically-aligned tables to quickly locate data associated with a given value. How to use VLOOKUP in Excel 1. Click the cell where you want the VLOOKUP formula to be calculated. 2. Click[b] Formulas[/b] at the top of the screen. 3. Click Lookup & Reference on the Ribbon. 4. Click VLOOKUP at the bottom of the drop-down menu. 5. Specify the cell in which you will enter the value whose data you're looking for. In this case, our lookup value is H2, since this is where we will input the name of a tournament such as "PGA Championship," so we input "H2" in the lookup_value box of the popup window. Once we've set up VLOOKUP properly, Excel will return the tournament's Total Rating Value in cell H3 when we type the tournament name in cell H2. 6. Specify the data that you want VLOOKUP to use for its search in the table_array box. In this case, we've selected the entire table (excluding the headers). 7. Specify the column number which VLOOKUP will use to find the relevant data in the col_index_num box. Somewhat confusingly, VLOOKUP requires you to use the numerical value of the column rather than its letter value. In this case, we want VLOOKUP to use the Total Rating Value column — column D — so we enter the number 4. 8. Specify whether you need an exact match by entering either FALSE (exact match) or TRUE (approximate match) in the range_lookup box. In this case, we want an exact match so we enter FALSE. 9. Click OK at the bottom of the popup window. 10. Enter the value whose data you're searching for. In our example, we want to find the Total Value Rating of the PGA Championship, so we type "PGA Championship" into cell H2 and VLOOKUP automatically produces the Total Value Rating (in this case, 914) in cell H3. Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one. For example, if you have one worksheet with names and phone numbers and another sheet with names and email addresses, you can put the email addresses next to the names and phone numbers by using VLOOKUP.

NB: Stories are shared by community members. The article does NOT represent the official view of NaijaWorld and the author is SOLELY RESPONSIBLE for this article
Comments

Use The App To Win N1m
Related Stories
thumbnail
Here Are The Top Highlights To Study In Vietnam!
thumbnail
Anambra State Government Honours Seahorse Boss, Onunkwo
thumbnail
School Resumption : What Lagos State Government Has To Say
thumbnail
Nigeria/ Czech Rep Discuss Bilateral Relations On Defense Cooperation, Education
thumbnail
Moment 400 Level Student Dies While Celebrating After Writing Final Exam
thumbnail
Stanbic IBTC University Scholarship For Young Nigerians 2021
thumbnail
2020 Institutions Admission By Quantum
thumbnail
Lagos Government Announces School Resumption Dates
thumbnail
Joseph Ugbene : See 65 Years Old Farmer Who Went Back To School
thumbnail
Academic Activities Paused As Massive Protest Hits Ibarapa Polytechnic
thumbnail
THE World University Rankings 2022: Seven Nigerian Universities Make The List
thumbnail
Online Learning: Tips And Strategies For Success
thumbnail
University Of Ibadan Once Again Tops The League!
thumbnail
48 Hours Deadline, We Are Yet To Hear From Govt – ASUU
thumbnail
Akwa Ibom Completed Recruitment Of 1000 Teachers For Secondary Schools…photos
Related Stories
thumbnail
Here Are The Top Highlights To Study In Vietnam!
thumbnail
Anambra State Government Honours Seahorse Boss, Onunkwo
thumbnail
School Resumption : What Lagos State Government Has To Say
thumbnail
Nigeria/ Czech Rep Discuss Bilateral Relations On Defense Cooperation, Education
thumbnail
Moment 400 Level Student Dies While Celebrating After Writing Final Exam
thumbnail
Stanbic IBTC University Scholarship For Young Nigerians 2021
thumbnail
2020 Institutions Admission By Quantum
thumbnail
Lagos Government Announces School Resumption Dates
thumbnail
Joseph Ugbene : See 65 Years Old Farmer Who Went Back To School
thumbnail
Academic Activities Paused As Massive Protest Hits Ibarapa Polytechnic
thumbnail
THE World University Rankings 2022: Seven Nigerian Universities Make The List
thumbnail
Online Learning: Tips And Strategies For Success
thumbnail
University Of Ibadan Once Again Tops The League!
thumbnail
48 Hours Deadline, We Are Yet To Hear From Govt – ASUU
thumbnail
Akwa Ibom Completed Recruitment Of 1000 Teachers For Secondary Schools…photos