| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up one value and return multiple corresponding values
Hi
I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in workbook "B". I do however also need to return a corresponding value from workbook "B". Suggestions? thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up one value and return multiple corresponding values
What's your VLOOKUP formula (as this is used to return a crresponding value)?
=VLOOKUP(A2,Sheet2!A:B,2,0) will return vlaue from column B on sheet2 where A2 (say sheet1) matches column A on sheet2. The 2 indicates return the second element (column B) in the range. HTH "Eric S." wrote: Hi I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in workbook "B". I do however also need to return a corresponding value from workbook "B". Suggestions? thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up one value and return multiple corresponding values
thanks for the fast response!
The VLOOKUP I use is: =VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$A$1368,1,FALSE) I noticed that when I change the "1" to "27" (column AA on the BCS GWE ES RESULTS.xls) I get a #REF! when there is a match.... "Toppers" wrote: What's your VLOOKUP formula (as this is used to return a crresponding value)? =VLOOKUP(A2,Sheet2!A:B,2,0) will return vlaue from column B on sheet2 where A2 (say sheet1) matches column A on sheet2. The 2 indicates return the second element (column B) in the range. HTH "Eric S." wrote: Hi I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in workbook "B". I do however also need to return a corresponding value from workbook "B". Suggestions? thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up one value and return multiple corresponding values
=VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$AA$1368,27,FALSE) should work "Eric S." wrote: thanks for the fast response! The VLOOKUP I use is: =VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$A$1368,1,FALSE) I noticed that when I change the "1" to "27" (column AA on the BCS GWE ES RESULTS.xls) I get a #REF! when there is a match.... "Toppers" wrote: What's your VLOOKUP formula (as this is used to return a crresponding value)? =VLOOKUP(A2,Sheet2!A:B,2,0) will return vlaue from column B on sheet2 where A2 (say sheet1) matches column A on sheet2. The 2 indicates return the second element (column B) in the range. HTH "Eric S." wrote: Hi I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in workbook "B". I do however also need to return a corresponding value from workbook "B". Suggestions? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return and sum up multiple values | Excel Worksheet Functions | |||
| Return multiple same values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Multiple conditions and multiple return values | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
![Eric S.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
