Compare Columns and Copy Data

  • Thread starter Thread starter lltaylor2000
  • Start date Start date
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?
 
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.
 
Back
Top