View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karl
 
Posts: n/a
Default Find match between 2 columns and then record data that is in colum

A B C D
UPCA UPCB INVENTORY RESULT
55 55 10
56 57 9
57 56 8
90 80 4
80 90 3
17 15 2

I need a formula that will find matches between column A+B then Record the
data that is in Column C in D. B+C are related fields (fixed)