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? |
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? |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com