Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
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 "Ron Coderre" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
Using Search with either vlookup or match and index | Excel Worksheet Functions | |||
how do i search an excel sheet for links to another spreadhseet? | Excel Discussion (Misc queries) | |||
spread sheet search | Excel Discussion (Misc queries) |