The default is ‘1’ TRUE if no value is entered.

The (optional) final argument in the formula, specifies ‘1’=TRUE for approximate match or ‘0’=FALSE for an exact match.

The fourth column will be looked in for the value to be found.

This cell reference will stay as G2 wherever it is copied to in the worksheet.

$G$2 denotes absolute column and absolute row ($ prefix before both elements of the cell reference).When the formula is copied down the column, the row number will increase but if the formula is copied across to another column, the column letter will remain as ‘F’. $F3 denotes absolute column ($ prefix to the column letter), relative row (no $ prefix to the row number).Note the mixture of absolute and relative cell references:.In the example above, the value to be looked up in the source range $B$3:$E$20 is created by combining ( concatenating) the contents of cells F3 and G2.= VLOOKUP ( ValueToLookup, TableRange of where to look, ColumnNumber of the table range to find the return value, True/False (1,0) - whether to take the closest match or to match the lookup value exactly) Syntax - VLOOKUP with CONCATENATE Syntax - basic VLOOKUP - see more about the VLOOKUP function Concatenate is used to combine cell values together for the lookup.

Purpose Look up values in a table, using Excel’s VLOOKUP and CONCATENATE functions.

Quick parts in excel 2016