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.


Kaugnay na mga set ng pag-aaral

ART3330- Chapter 4-5 study guide

View Set

Science Benchmark Answer Key Pt 3

View Set