Group and UnGroup

Data -> Group or Ungroup

Here this will group or ungroup rows or columns in a sheet.

VLOOKUP - LOOKUP- HLOOKUP

VLOOKUP: Looks up for the value in column mentioned in par3 from a row that macthes with value in par1 and datasource range mentioned.

VLOOKUP(parl,par2,par3,par4)

Has 4 parameters:

par1 - Your input data(cell or column name).
par2 - Your souce data(exclude columns). It could be from other sheets too
par3 - Column name from where you wanted to pull the data
par4 - true or false(exact match)