View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sung Sung is offline
external usenet poster
 
Posts: 9
Default Comparing two sets of columns

Hi Everyone,

I had a question regarding comparing two sets of data. So for example, i
have a set of data with account numbers and payment amounts. I want to
compared a loan amount and a payment amount from another data set to
determine if there is a match on both criteria.

Loan number Payment Amount
12345 100
45678 200
95844 300

I want excel to check to see if loan numbers and payment amounts from
another set match the one i have.

thanks