how do i use vlookup to search for a value on another sheet?

D

Danz

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
 
R

Ron Coderre

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
 
P

Peo Sjoblom

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
 
D

Danz

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top