| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with MATCH function
Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I
am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the second match using the match function | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Threaded Mode
