Question:

Is it possible to use the "vlookup" function of excel to copy data from the entire column of sheet1 to sheet2?

by  |  earlier

0 LIKES UnLike

Is it possible to use the "vlookup" function of excel to copy data from the entire column of sheet1 to sheet2?

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. technically...yes it is possible

    if you want to copy the A column, then just copy this formula in sheet2:

    =VLOOKUP(Sheet1!A1,Sheet1!A:A,1,FALSE)

    then copy&paste down.

    but you wouldnt want to do that.

    you could just use

    =Sheet1!A1

    and copy the formula down.

    or else just copy the column, and paste where you want.

You're reading: Is it possible to use the "vlookup" function of excel to copy data from the entire column of sheet1 to sheet2?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now