Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Columns and Copy Data
Hi,
I could use some advice. I have a spreadsheet with 4 columns Column A = Master List of Order Numbers (i.e. all orders ever) Column B = Order Description Column C = Ordered By I then have a column which has the latest order numbers (copied from some where else). Column D = Partial Order Numbers So this is what I need to do. I need to 1 verify all the order numbers in Column D exist in Column A (as they may not do). I have done this using the MATCH function however...... I then to copy over the associated data in Columns B & C so I have by validated list of ORDERS, DESCRIPTION and ORDERED BY. (I am stuck on how to do this). This is a one of process for 10,000 rows of data, and I just need a quick fix to validate and copy the information I need. Any ideas? Thanks in Advance Any tips? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Columns and Copy Data
Assume column E has your match function and it displays an error when there
is not match In F2 =if(isnumber(E2),Vlookup(D2,A:C,2,False),"") in G2, =if(isnumber(E2),Vlookup(D2,A:C,3,False),"") select F2:G2 and drag fill down the column. -- Regards, Tom Ogilvy " wrote: Hi, I could use some advice. I have a spreadsheet with 4 columns Column A = Master List of Order Numbers (i.e. all orders ever) Column B = Order Description Column C = Ordered By I then have a column which has the latest order numbers (copied from some where else). Column D = Partial Order Numbers So this is what I need to do. I need to 1 verify all the order numbers in Column D exist in Column A (as they may not do). I have done this using the MATCH function however...... I then to copy over the associated data in Columns B & C so I have by validated list of ORDERS, DESCRIPTION and ORDERED BY. (I am stuck on how to do this). This is a one of process for 10,000 rows of data, and I just need a quick fix to validate and copy the information I need. Any ideas? Thanks in Advance Any tips? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare cells and copy columns after match | Excel Worksheet Functions | |||
Compare 4 columns and copy | Excel Discussion (Misc queries) | |||
how to compare two columns on two sheets and copy associated data from one sheet to the other? | Excel Worksheet Functions | |||
Need to compare data in 2 columns and not sure how. | Charts and Charting in Excel | |||
Compare/Copy columns from two books? | Excel Programming |