comparing values and returning different column

Try VLOOKUP again but with this small modification

=VLOOKUP(B2,SHEET2!$A$1:$B$100,2,FALSE).

The previous example was trying to look in the second column of a single column array!
Hence the #REF error.

Mark.

My typing is too slow.
rolleyes:

I now understand the error and indeed the vlookup function is working perfectly. Thanks for all the information.


JustMe602

Originally Posted by Mark@Work

My typing is too slow.
rolleyes:

Your typing isn't too slow. You just chose to use the red font to display the error, which gave me the slight advantage.