| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find matching data in two worksheet columns
I have a worksheet that has two columns of data. The first column contains
the data that I'm trying to match or find in a second column. I then need it to show me the data that is the same in both columns. What's the best way to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find matching data in two worksheet columns
vlookup would be your best approach.
"scootter" wrote in message ... I have a worksheet that has two columns of data. The first column contains the data that I'm trying to match or find in a second column. I then need it to show me the data that is the same in both columns. What's the best way to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find matching data in two worksheet columns
Here's the function I entered. Column A contains the data I want to match or
find in column E. The problem is if the number in column E doesn't match the number in column A the result shows as the number that's in column E. I've done something wrong... =VLOOKUP(A$2:A$33,A$2:E$33,5,FALSE) "Naraine Ramkirath" wrote: vlookup would be your best approach. "scootter" wrote in message ... I have a worksheet that has two columns of data. The first column contains the data that I'm trying to match or find in a second column. I then need it to show me the data that is the same in both columns. What's the best way to do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find matching data in two worksheet columns
Okay...let's try this again. I have a worksheet with 5 columns of data. One
column contains about 1000 part numbers and one column contains about 10,000 part numbers. I'd like to find the common part numbers in these two columns. Is this possible? "scootter" wrote: Here's the function I entered. Column A contains the data I want to match or find in column E. The problem is if the number in column E doesn't match the number in column A the result shows as the number that's in column E. I've done something wrong... =VLOOKUP(A$2:A$33,A$2:E$33,5,FALSE) "Naraine Ramkirath" wrote: vlookup would be your best approach. "scootter" wrote in message ... I have a worksheet that has two columns of data. The first column contains the data that I'm trying to match or find in a second column. I then need it to show me the data that is the same in both columns. What's the best way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching 2 columns of data | Excel Discussion (Misc queries) | |||
| matching data in columns | Excel Discussion (Misc queries) | |||
| Find Matching Data Two Columns | Excel Worksheet Functions | |||
| Matching Data in Columns | Excel Worksheet Functions | |||
| MATCHING DATA IN COLUMNS | Excel Worksheet Functions | |||
Hybrid Mode
