| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two lists and returning value from different column
I am trying to compare two parts lists to each other to determine if there
are matches within the data. If that data matches i would like to return the part number and description from different cells of the parts that matched. In addition to finding the ones that match is there a way to sort the parts that "don't match". Example of what i'm looking at is below.... 9008011597 643330E010 Bolt Washer 643490E010 9046709204 Nut Screw 521270E010 521280E010 6221713010 647180E010 9008011602 9008011603 9008011604 9008011620 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing two lists and returning value from different column
What is the layout of your data? Are both lists in the same sheet?
Different sheets? Different files? What columns of each list do you want to check for matches? What columns do you want copied from which list to which list and in what columns do you want the copied data pasted? HTH Otto "Duser" wrote in message ... I am trying to compare two parts lists to each other to determine if there are matches within the data. If that data matches i would like to return the part number and description from different cells of the parts that matched. In addition to finding the ones that match is there a way to sort the parts that "don't match". Example of what i'm looking at is below.... 9008011597 643330E010 Bolt Washer 643490E010 9046709204 Nut Screw 521270E010 521280E010 6221713010 647180E010 9008011602 9008011603 9008011604 9008011620 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing two lists and returning value from different column
I have a question similiar. Basically one sheet has multiple columns each holding different information about an item. Each item has its own row. On another sheet I have one column that shares a name with one of the columns on the previous sheet. Sheet 1 Name Phone Address City State Zip Jon Doe 555555 newhere nowhere st 55555 Jon Doe2 555555 newhere nowhere ni 55555 Jon Doe2 555555 newhere nowhere st 55555 Jon Doe3 555555 newhere nowhere st 55555 Jon Doe4 555555 newhere nowhere me 55555 Sheet 2 State st ni What I would like to do is filter the state column on Sheet 1 by the contents of the State column on sheet 2. A couple issues are Sheet 2 is pulling data from a web query so the contents will change. Meaning sometimes it might pull only two items, another time it may be 20 or more. -- mrbernz ------------------------------------------------------------------------ mrbernz's Profile: http://www.excelforum.com/member.php...o&userid=32814 View this thread: http://www.excelforum.com/showthread...hreadid=526208 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing two lists and returning value from different column
Yours would take a relatively elaborate macro to check each State item on
sheet 2 and see if it existed in the State column in Sheet 1 and if so run a Autofilter on that criteria and copy and paste those results to another "Report" sheet, then clear the autofilter and then step down and do the same thing with each item in State on sheet 2 and append each Autofilter results to the bottom of the Report sheet list..... It is definately do-able, but only justified if you have do do this exercize frequently..... hth Vaya con Dios, Chuck, CABGx3 "mrbernz" wrote in message ... I have a question similiar. Basically one sheet has multiple columns each holding different information about an item. Each item has its own row. On another sheet I have one column that shares a name with one of the columns on the previous sheet. Sheet 1 Name Phone Address City State Zip Jon Doe 555555 newhere nowhere st 55555 Jon Doe2 555555 newhere nowhere ni 55555 Jon Doe2 555555 newhere nowhere st 55555 Jon Doe3 555555 newhere nowhere st 55555 Jon Doe4 555555 newhere nowhere me 55555 Sheet 2 State st ni What I would like to do is filter the state column on Sheet 1 by the contents of the State column on sheet 2. A couple issues are Sheet 2 is pulling data from a web query so the contents will change. Meaning sometimes it might pull only two items, another time it may be 20 or more. -- mrbernz ------------------------------------------------------------------------ mrbernz's Profile: http://www.excelforum.com/member.php...o&userid=32814 View this thread: http://www.excelforum.com/showthread...hreadid=526208 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing two lists and returning value from different column
With one list in column A, and the second list in column B, and your lookup
table in columns G:I, then put this in C1 and copy down, =IF(VLOOKUP(B1,A:A,1,FALSE)=B1,VLOOKUP(B1,G:I,2,FA LSE),"") and put this in D1 and copy down..... =IF(VLOOKUP(B1,A:A,1,FALSE)=B1,VLOOKUP(B1,G:I,3,FA LSE),"") Vaya con Dios, Chuck, CABGx3 "Duser" wrote in message ... I am trying to compare two parts lists to each other to determine if there are matches within the data. If that data matches i would like to return the part number and description from different cells of the parts that matched. In addition to finding the ones that match is there a way to sort the parts that "don't match". Example of what i'm looking at is below.... 9008011597 643330E010 Bolt Washer 643490E010 9046709204 Nut Screw 521270E010 521280E010 6221713010 647180E010 9008011602 9008011603 9008011604 9008011620 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value if data is in a large list | Excel Discussion (Misc queries) | |||
Hybrid Mode
