| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I match values in one spreadsheet to values in another?
I am trying to match some numbers from a column in one spreadsheet to the
numbers from another spreadsheet. I basically want to match up which numbers are in both lists. I also want to bring the information from other columns with that number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I match values in one spreadsheet to values in another?
vlookup is your friend =VLOOKUP(A1,'Sheet 1'!A:B,2,FALSE) where by A1 is the value you need to look up Sheet 1 is where you're looking into. Column 1 is always the "looked up" range and the 2 is the column number of where the information you wish to pull back is held. Make sure you enter false at the end so that you don't have to worry about the list being sorted. If it comes back as #n/a then the value doesn't exist in the reference range. -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=571745 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I match values in one spreadsheet to values in another?
Sounds good-will try and let you know if it I get hung up. Thanks.
"mr_ben" wrote: vlookup is your friend =VLOOKUP(A1,'Sheet 1'!A:B,2,FALSE) where by A1 is the value you need to look up Sheet 1 is where you're looking into. Column 1 is always the "looked up" range and the 2 is the column number of where the information you wish to pull back is held. Make sure you enter false at the end so that you don't have to worry about the list being sorted. If it comes back as #n/a then the value doesn't exist in the reference range. -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=571745 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to match values in one column to values in another? | Excel Worksheet Functions | |||
| How can I match up values from 2 sheets and info in adjoining cell | Excel Discussion (Misc queries) | |||
| Removing zero values from a spreadsheet. | Excel Discussion (Misc queries) | |||
| Need formula to find and sum values in a different spreadsheet | Excel Worksheet Functions | |||
| Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions | |||
Linear Mode
