Now lets start. Here we have two sheets called the “Base Sheet” and the “Output Sheet".
Once you have locked the cells as an absolute cell reference, copy and paste the formula in the rows below. Now you are done with the vlookup. All the data is now available in the format you wanted.
Now, in order to do a vlookup on a different sheet or on a different file use the same method. The only difference would be while doing on a different sheet it will give the reference of that sheet or that file from where we are doing the vlookup. Also do keep a check on that you have locked the cells of the range from where you are doing the vlookup.
Once you are done with the vlookup in a cell on a different sheet, copy and paste the same formula in the other rows as shown below.