Using the VLOOKUP function in Microsoft Excel


1. Open the document you want to work with





https://files.bigwebapps.com/File.ashx?FileId=urmb20iqrsryl38mj0p9qu62bjosy8c2&E=635249901439667380.60&H=jyF0EJEIfHfMI5KaOT6wmVmKRanxoZ16ZriV%2b1YT6pA%3d&Width=800&Height=0&Align=0" alt="">



2. Add or go to your new field





https://files.bigwebapps.com/File.ashx?FileId=ckfdf4v751lpuld2mbc803bm9mw2l0wk&E=635249901923804478.60&H=%2fc%2blVGItBSmWMCi%2f%2bqx%2fwjjxgggSkw8atrIiYuI7OaE%3d&Width=800&Height=0&Align=0" alt="">



3. Find or add the information table you would like to look up (they can be listed in any order)





https://files.bigwebapps.com/File.ashx?FileId=n2huk9h5vgw8kx8m22ppxxshwjdmupp6&E=635249902150214653.60&H=fs1jEQ1tUf4q8%2fzVJO3i9Xq5ObwXD3Zr17SnYYPZK0w%3d&Width=800&Height=0&Align=0" alt="">



4. For “Grade”, insert the VLOOKUP function (=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])



a. lookup_value defines the value of the number which we will be looking for in the newly created or referenced table (example below = cell D2)





b. table_array defines the table we will be referring to (example below = H7:I12)





c. col_index_num defines data from which column, from the table_array we want to extract values to show (example below = column 2 [I] from the table H7:I12)





d. range_lookup lets you choose an option either true (approximate match of values) or false (exact match of values)





https://files.bigwebapps.com/File.ashx?FileId=qy5gbwkjawtg7opqlyxi95x0s621nloi&E=635249903005504116.60&H=N%2fzjFj2EVGimjURjO80YYfSA7Szq2YVWlEbwlrio4AQ%3d&Width=800&Height=0&Align=0" alt="">



Enter this into desired cell (E2), press enter





Example was put into E2 using information from H7-I12 which generated the grade of “A”





https://files.bigwebapps.com/File.ashx?FileId=nyeoyds7ocvjfn4etilxgoeavbxtggp4&E=635249903320011290.60&H=%2fumD0oST7NDJCC01GAeX9x0a0gJIo7Jt01f%2bNUp6VoU%3d&Width=800&Height=0&Align=0" alt="">



5. Hover over the highlighted cell black box. Watch the bottom right corner until you get the ‘+’. Click and Drag down through where you want the equation to fill the remaining cells.





https://files.bigwebapps.com/File.ashx?FileId=hat8getjb83qevvydfm26v0xcxekm537&E=635249903520074856.60&H=Cjoo4XnTEAFy8t4Rmg2lyXiomYNHELNWAOz7%2fGG7UD4%3d&Width=800&Height=0&Align=0" alt="">





https://files.bigwebapps.com/File.ashx?FileId=iq31b9aga1flt4rfpnf1qgpoc0tqlwos&E=635249903593532883.60&H=qOAKt5BT3qvBtYQB%2fRSGzyqTf5nsXY0NbnXCTumOlr0%3d&Width=800&Height=0&Align=0" alt="">



6. For “Prize Money” type in the VLOOKUP equation this time using “False” instead of “true” and changing the information to the new information you need





https://files.bigwebapps.com/File.ashx?FileId=jsuqgj0vf8fjeeu8abmvh9e5jfesxgmh&E=635249903834226656.60&H=CjOeTQAkbkfV4XK247pawMoQ4f9PPkfy7UWjCJW%2b9xY%3d&Width=800&Height=0&Align=0" alt="">





Example was placed in F2 using information from H14-I19





https://files.bigwebapps.com/File.ashx?FileId=9icss1x54nxrqgxopo97enqhl4m3p5ik&E=635249904011530134.60&H=Twk8uZYg0q4PfokKN8a0hp5wf8U0jWo6qPaFyOosCB8%3d&Width=800&Height=0&Align=0" alt="">

 I found this article helpful. (0)