Forum Discussion
if the value in one list exists in another array.
It's difficult to decipher exactly what you need, but to check if the values in one list exist in another, you can use either COUNTIF (works only with ranges) or ISNUMBER-MATCH (also works with arrays).
Note: the value in cell A8 in your sample file is "MRGYO", whereas the value in cell Y26 on the input sheet is "MGRYO". You will need to correct one or the other for them to match.
Please see the attached workbook for the complete updated formula. This is my best guess at what you wanted...
It's difficult to decipher exactly what you need, but to check if the values in one list exist in another, you can use either COUNTIF (works only with ranges) or ISNUMBER-MATCH (also works with arrays).
Note: the value in cell A8 in your sample file is "MRGYO", whereas the value in cell Y26 on the input sheet is "MGRYO". You will need to correct one or the other for them to match.
Please see the attached workbook for the complete updated formula. This is my best guess at what you wanted...
Thanks for your efforts.
