copy formula, VLOOKUP

[BRustigian]

Unable to copy formula to other cells
=VLOOKUP(A2,Sheet2!$A$1:$B$4,Sheet2!$A$1:$A$4,FALSE). I have trie
everything I can think of to copy this formula. Thank yo

 

[Debra Dalgleish]

The third argument should be the column number from which you want to
return the result. Since your range is only two columns, your formula
could be:

=VLOOKUP(A2,Sheet2!$A$1:$B$4,2,FALSE)