You can't return the value from the second column of sheet2!A2:A84 if it only
contains 1 column.

Try this:
=VLOOKUP(B2,sheet2!A2:B84,2,0)

Instead of this:
=VLOOKUP(B2,sheet2!A2:A84,2,0)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Danz" wrote:

I have 2 sheets
Sheet 1 contains value to search for
sheet 2 contains column 1 with range of values
sheet 2 column 2 contains corresponding values to return to sheet 1

I have the formula set up as this
=VLOOKUP(B2,sheet2!A2:A84,2,0)

It gives me a #REV! error