| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using If Statement
Hello, I would like to compare to excel file 2 excel file cell/column and
check if it is different. here is my idea: IF xls1 A2 is found in xls2 column B(ANY CELL IN COLUMN B) then check IF xls1 B2 is equal to xls2 B(CELL OF THE RESULT ABOVE) IF equal then input "ok" in xls1 F2 If not equal input "wrong" in xls1 F2 else input "not found" in xls1 F2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Using an IF statement, or VLOOKUP statement | Excel Programming | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
