View Single Post
  #1   Report Post  
ch90
 
Posts: n/a
Default compare two columns and display a third

here's the challenge:
-I need to compare 2 columns: A1:A10 and B1:B20 (different range)
-For each common value I would like to display the information contained in
a third column C1:C20

I did some research on this forum and http://www.cpearson.com/ but so far no
good.
any help will be greatly appreciate to avoid doing it manually 2000 times.

chris90