copy formula, VLOOKUP

B

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
 
D

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)
 
Top