software

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

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-Proquot;Danzquot; wrote:

gt; I have 2 sheets
gt; Sheet 1 contains value to search for
gt; sheet 2 contains column 1 with range of values
gt; sheet 2 column 2 contains corresponding values to return to sheet 1
gt;
gt; I have the formula set up as this
gt; =VLOOKUP(B2,sheet2!A2:A84,2,0)
gt;
gt; It gives me a #REV! error

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

nwexcelsolutions.comquot;Danzquot; gt; wrote in message
...
gt;I have 2 sheets
gt; Sheet 1 contains value to search for
gt; sheet 2 contains column 1 with range of values
gt; sheet 2 column 2 contains corresponding values to return to sheet 1
gt;
gt; I have the formula set up as this
gt; =VLOOKUP(B2,sheet2!A2:A84,2,0)
gt;
gt; It gives me a #REV! error
That solved my problem. I didn't realise that I had to include all the
columns that I am trying to find data.
For the longest time, I was trying to figure out how to reference sheet2 for
column2.

Thanks for the quick help.
Danz

quot;Ron Coderrequot; wrote:

gt; You can't return the value from the second column of sheet2!A2:A84 if it only
gt; contains 1 column.
gt;
gt; Try this:
gt; =VLOOKUP(B2,sheet2!A2:B84,2,0)
gt;
gt; Instead of this:
gt; =VLOOKUP(B2,sheet2!A2:A84,2,0)
gt;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Danzquot; wrote:
gt;
gt; gt; I have 2 sheets
gt; gt; Sheet 1 contains value to search for
gt; gt; sheet 2 contains column 1 with range of values
gt; gt; sheet 2 column 2 contains corresponding values to return to sheet 1
gt; gt;
gt; gt; I have the formula set up as this
gt; gt; =VLOOKUP(B2,sheet2!A2:A84,2,0)
gt; gt;
gt; gt; It gives me a #REV! error

Solved the problem.

Thanks for the very quick reply.

Danz

quot;Peo Sjoblomquot; wrote:

gt; You need to change sheet2!A2:A84 to sheet2!A2:B84 if you want the value from
gt; column B,
gt; right now you tell excel to find the 2nd column in one column thus the REF
gt; error
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Danzquot; gt; wrote in message
gt; ...
gt; gt;I have 2 sheets
gt; gt; Sheet 1 contains value to search for
gt; gt; sheet 2 contains column 1 with range of values
gt; gt; sheet 2 column 2 contains corresponding values to return to sheet 1
gt; gt;
gt; gt; I have the formula set up as this
gt; gt; =VLOOKUP(B2,sheet2!A2:A84,2,0)
gt; gt;
gt; gt; It gives me a #REV! error
gt;
gt;
gt;