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...
Смотрите видео Excel: Vertical Lookup Function (VLOOKUP) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Fifteensecs Uknow 03 Декабрь 2012, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,474 раз и оно понравилось 0 людям.