EXCEL VLOOKUP
Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!
Vlookup format...
=vlookup(lookup_value, table_array, column_index_value, range_lookup)
range_value...
always left blank.
table_array...
array of cells that contain the lookup table. (a defined name)
Vlookup...
excel function that allows you to look up a value from a table.
lookup_value...
must be in the first column.
column_index_value...
the column with the value you want the vlookup to return.