Excel Tips, Tricks, and Shortcuts

In Excel table with data entry, if you want to look for a value from a table array in the first column you refer to and get return an equivalent value in the same row from another column in the table array. This case, suppose you will search for the data from the table array from the right column and returns data associate in the left column and the same row. The formula to use is “VLOOKUP” Formula Syntax =VLOOKUP (lookup_value,table_array,col_index_num,range_lookup) * Data in the table array (F column) have to be sorted by ascending order, otherwise, the return value may give an unexpected/incorrect value data. Do you find this article useful? See more other tips: Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First Row/Column Formula “LOOK UP” For Using Approximate Match Values Sorted Ascending Order In a List Method of Extract the Specified Characters from the End of Text String Content You might like my another blog: Learn Thai ...