Comparing columns

Hedgecutter

Hi I have two columns of ID numbers on a spread sheet, column 1 has ID numbers that have been imputed into and stored with in an ERP management system, column 2 are all the ID number from the customer.

What I want to do is compare each column and find the ID numbers that are NOT in the management system (column 1).

I need to find ID numbers that have not been inputted in to the system yet.

Iv tried Vlookup and match but cant get it to work.

Attached is an example of the numbers in the columns.

The actual spread sheets have around 100 ID numbers.

Any help would be appreciated.

jus_tin4

Hedgecutter wrote: »

Hi I have two columns of ID numbers on a spread sheet, column 1 has ID numbers that have been imputed into and stored with in an ERP management system, column 2 are all the ID number from the customer.

What I want to do is compare each column and find the ID numbers that are NOT in the management system (column 1).

I need to find ID numbers that have not been inputted in to the system yet.

Iv tried Vlookup and match but cant get it to work.

Attached is an example of the numbers in the columns.

The actual spread sheets have around 100 ID numbers.

Any help would be appreciated.

Vlookup should work for this, I can’t see the excel so I’ll just try explain the Best I can

=vlookup(cell1,all of column1,1,0)

This will return a value if no in col 1 appear in col 2. Return n/a if the number isn’t there

Hedgecutter

Thanks its is working now, problem I notices is one column is copied from one spread sheet and has blank spaces after the numbers and the other column copied from some one else's spread sheet and has no blank spaces after the numbers.

Is there a way to paste both the same and remove those blank spaces?

drdidlittle

Hedgecutter wrote:

Is there a way to paste both the same and remove those blank spaces?

Try multiply number by 1 or else try trim function