Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare Two Cells
Hello,
I would like to ask for help with a worksheet. There are two cells I need help with. These cells list vehicle VIN Numbers. One column was reported by hte driver, the other column was reported by the vendor. I need a formula that will look at A1 and B1 and tell me in C1 if they are different numbers. If hte numbers match, the cell can remain empty, but if the cells are different I would like to return some indicator. Thanks in advance for hte help. Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare Two Cells
You might try this formula:
=IF(A1=B1,"match","mismatch") ....then copy and paste that formula over the rest of the range. The English translation is: Compare the entry in A1 to the entry in B1. If the match, return the word "match". If they do not match, return the word "mismatch". Dave O Eschew obfuscation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two cells with same name | Excel Worksheet Functions | |||
CAn IF compare two cells? | Excel Worksheet Functions | |||
Compare 400 cells to one | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Compare two cells from reference cells | Excel Worksheet Functions |