## Question:

I have a question and I can't get a plausible answer.

I have a spreadsheet where I would like to do a comparison between two columns and tell it that if there is a value that is not duplicated, that same value will be moved to a new column. For example:

I have Column " **A** " and " **B** ", in these columns there is a sequence of 6-digit numbers, for example:

```
A B
519294 519522
519364 519499
519365 519501
519366 519500
519381 519494
519382 519492
519389 519493
519422 519491
519428 519483
```

I want to make a comparison of column "A" using column "B", if the value of column "A" is not found in column "B" this same value must be moved to a new column "C" for example.

If possible I would like to use a formula or a VBA that performs this query and if it was a false value where that value was not found in column "B" it could be moved.

I am very grateful if anyone can help me with a VBA or Formula.

## Answer:

Will a VLOOKUP combined with SE and SEERRO not solve you?

```
=SE(SEERRO(PROCV(A1;B:B;1;FALSO);0)=0;A1;"")
```

Explanation: If VLOOKUP returns an error indicating that the value in A was not found in B, the formula returns the value of A. If the value in A is found in B, the formula returns empty ("").