The Excel VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position.The syntax of the VLOOKUP function is as below:= VLOOKUP (lookup_value, table_array, column_index_num,)…. Type this formula into a blank cell and press Enter key to apply it. Note: the above formula only returns a relative row number, and if you want to get a absolute row number, you can use another formula based on the ROW function and the MATCH function, like this: = MATCH("excel",A1:A5,0) + ROW(A1:A5)-1 You would see that the row number returned. You need to type this formula into a desired cell and press Enter key to apply this formula. For example, you want to lookup a string value “excel” in range A1:A5 and return the row number where the searching value is found. If you want to return a row number from a Vlookup, you can use a formula based on the MATCH function.
0 Comments
Leave a Reply. |