Table_array (required argument) – The table array is the data array that is to be searched.Lookup_value (required argument) – Lookup_value specifies the value that we want to look up in the first column of a table.The VLOOKUP function uses the following arguments: To translate this to simple English, the formula is saying, “Look for this piece of information, in the following area, and give me some corresponding data from another column”. =VLOOKUP(lookup_value, table_array, col_index_num, ) Learn how to do this step by step in our Free Excel Crash Course!
In simple terms, the VLOOKUP function says the following to Excel: “Look for this piece of information (e.g., bananas), in this data set (a table), and tell me some corresponding information about it (e.g., the price of bananas)”. The VLOOKUP Function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information.
0 kommentar(er)
