Excel: Vertical Lookup Function (VLOOKUP)
Program: Excel 2010
Instructions:
Formula
=VLOOKUP(lookup_value, table_array, col_index_num, false)
lookup_value is the search value; value we want to get the information from
for this example, it is cell reference 'H10' as we will look at what fruit
table_array is the range of cells that contains data we will be getting from
for this example, it is A3:F9 where all the data from
col_index_num is the column number in the table_array
for this example, we want information for Wednesday which is located in column 4 from table_array
Note: to make a drop down list for cell renference H10 (like the video), please see the tutorial at • Excel: Create Drop Down List (Data Va...
Complete TOC with other lessons: https://docs.google.com/spreadsheet/c...
Watch video Excel: Vertical Lookup Function (VLOOKUP) online without registration, duration hours minute second in high quality. This video was added by user Fifteensecs Uknow 03 December 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,474 once and liked it 0 people.