Lookup And Reference Function In Excel. Returns a reference indicated by a text value. Use lookup one of the lookup and reference functions when you need to look in a single row or column and find a value from the same position in a second row or column.
This argument can be a cell reference or a fixed value such as smith or 21 000. For vlookup this first argument is the value that you want to find. The vlookup vertical lookup function looks for a value in the leftmost column of a table and then returns a.
Excel function reference lookup and reference excel functions by category.
This argument can be a cell reference or a fixed value such as smith or 21 000. This argument can be a cell reference or a fixed value such as smith or 21 000. Use lookup one of the lookup and reference functions when you need to look in a single row or column and find a value from the same position in a second row or column. For example let s say you know the part number for an auto part but you don t know the price.