| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND statement with cell range
I am trying to compare 2 cells against a range to determine if there is a
match: Col A Col B Col C Col D MARY BROWN TED SMITH TED SMITH BOB JONES I'm using =IF(AND(C3=$A:$A,D3=$B:$B),"YES","NO") but it's obviously wrong because I'm getting "NO" when it should return "YES". What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF STATEMENT Range | Excel Discussion (Misc queries) | |||
| range in an IF statement | Excel Worksheet Functions | |||
| if statement with a range without a cell reference ie, #s 1100 to | Excel Worksheet Functions | |||
| IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
| Nested IF statement with cell range reference | Excel Worksheet Functions | |||
Threaded Mode
