| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF statement help needed
I have two sheets where I need to match up three values. If the values from
Row 1 of Column B, R and U on Sheet 1 matches the value of Columns C, AE and AX on sheet 2 (any row), I want the word Match to appear and if all three conditions are not met, Investigate should appear. Here is a disaster formula I have put in so far. =IF($B1=Sheet2!C2:Sheet2!C30000)AND(IF($R1=Sheet2! AE2:Sheet2!AE30000))AND(IF($U1=Sheet2!AX2:Sheet2!A X30000)),"MATCH","INVESTIGATE") Any assistance is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement ... help needed. | Excel Worksheet Functions | |||
| IF STATEMENT HELP NEEDED!!! | Excel Discussion (Misc queries) | |||
| If Statement help needed please | Excel Worksheet Functions | |||
| If statement help needed | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Threaded Mode
