Column D contains the Remarks where the results will be returned by VLOOKUPįigure 2 – Setting up the Data Using the VLOOKUP Function in the LOOKUP TABLE.We will enter the expenditure into Column B.We will use the LOOKUP TABLE to ascertain based on the comment in Column H if we will proceed with the stated expenditure in COLUMN C as shown in figure 2. =VLOOKUP(C4,$G$4:$H$6,2) Setting up the Data If omitted, VLOOKUP assumes an approximate match Range_lookup: This is used to specify if we want and approximate or exact match of the lookup value.Col_index_num: This number specifies the column where we want the value to be returned from.
=VLOOKUP(lookup_value,table_array,col_index_num,) The steps below will walk through the process.įigure 1- How to Create and Use a LOOKUP Table in Excel Syntax The LOOKUP TABLE allows us to evaluate cells and input an associated comment or remark. We can create and use a LOOKUP TABLE in excel for sorting large amount of data. How to Create and Use a LOOKUP Table in Excel
