Thread: compare 2 columns of numbers and place the matched numbers in a 3r
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default compare 2 columns of numbers and place the matched numbers in a 3r
Maybe this...

=IF(COUNTIF(C:C,A2),A2,"")

Copy down as needed

--
Biff
Microsoft Excel MVP


"Clive" wrote in message
...
Hi.
I am a newcomer and I need your help.
I need a formula that can compare a column of numbers (Column A)
"LabMaster"
with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched
number to Column B, adjacent to its match in Column A "Labmaster.
(Possibly 4,000 numbers in "Labmaster".

Thanks
Clive


Reply With QuoteReply With Quote