L
lltaylor2000
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?
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?