Scan column for numbers and report ones not found

Originally Posted by Badvgood

Morning all,

I need a formula that can scan columns L M N O P Q for numbers that are found in column C and report the numbers that are not found.

In the end I want to end up with a list of numbers that are in them 6 columns that do not appear in column C.

Any ideas?

BVG

Hi,

6 helper columns that use something like

=if(IsError(VLookup(L1,$C:$C,1,False)),L1,"")

formula fill 5 right and down as far as required.

hth
---