Knowledge is power essay

 Following procedure to use replace tool. Select the shell want to replace portion in that shell. Press CTL+F. Click on replace. Then two box would be diplayed. In one box of find what ,enter the poertion want to replace. Another shell of Replace with , enter the portion you want to change from find what box portion . Then click on replace. Then that portion would be replaced.

  VLOOKUP function says:: +VLOOKUP(What you want to look up,where you want to lookfor it,the coloumnn number in the range containing the value to return,return an approximate or an exact match indicate  as 1 or 0) To do blank the error report, followng formula         +IFERROR(VLOKUP(             ), "")