Solved the problem.

Thanks for the very quick reply.

Danz

"Peo Sjoblom" wrote:

You need to change sheet2!A2:A84 to sheet2!A2:B84 if you want the value from
column B,
right now you tell excel to find the 2nd column in one column thus the REF
error

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Danz" wrote in message
...
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