Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two sets of columns
Depending on what you mean by this i think there is two ways you can do it. Try
=IF(AND(MATCH("100",Sheet1Range,0),MATCH("12345",S heet1Range,0),"Match","Not A Match") Or =IF(VLOOKUP("12345",Sheet1Range,2,FALSE)="100","Ma tch","Not a Match" It would be easier to reference the cells, so if A2 has 12345 in it, then substitue 12345 with A2. And Sheet1Range for the first equation would be a single column, in the second equation it would be the entire loan # and payment amounts. "Sung" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two sets of columns
It works perfect. thank you very much
"AKphidelt" wrote: Depending on what you mean by this i think there is two ways you can do it. Try =IF(AND(MATCH("100",Sheet1Range,0),MATCH("12345",S heet1Range,0),"Match","Not A Match") Or =IF(VLOOKUP("12345",Sheet1Range,2,FALSE)="100","Ma tch","Not a Match" It would be easier to reference the cells, so if A2 has 12345 in it, then substitue 12345 with A2. And Sheet1Range for the first equation would be a single column, in the second equation it would be the entire loan # and payment amounts. "Sung" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two different sets of data with common element | Excel Worksheet Functions | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
Combining information in sets of columns | Excel Discussion (Misc queries) | |||
Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions |