Need a quick answer on this one........

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

I have three columns of numbers....I need to find exact matches between 2 of
them. If a match is found I need to copy a number from the other column to
an empty column. For example, if any number in column B matches any number
in column C, then copy the number in A (next to the match it found in B) to
column D.

I hope that makes sense.

Thanks,
Dan
 
can you put column A in column c?
and sort the reference column (column a - previously
column b) in ascending order.
formula in column d: =IF(ISNA(VLOOKUP
(C4,A$4:B$10,2,FALSE)),0,VLOOKUP(C4,A$4:B$10,2,FALSE))

Hope that helps
 
Back
Top