| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching function or no match
I am using this formula to compare 2 list to see which numbers are not included in both column A and Col C. The formula I am using below pulls out the ones that i do have a match . Is there another function that I could use that would only pull out the ones that there is not a match? =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If two criteria match then sum matching values in another column | Excel Worksheet Functions | |||
| Four criteria MATCH INDEX lookup of date between matching two text | Excel Worksheet Functions | |||
| MATCH function not matching as expected | Excel Worksheet Functions | |||
| Matching cells and adding a value to the match. | Excel Worksheet Functions | |||
| Search & match more than one worksheet and matching cells. | Excel Worksheet Functions | |||
![Donna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
