Hi,
I'm trying to figure out a way to do a simple data check. I have two rows of data, both have the exact same numbers/Text If one of the numbers/Text changes i need it to post a text of "Not A Full Match" if both data sets a equal i need it to say "Match". The formula I'm currently using works, but it only works for 1 value. I need it to work for an array of data. Any ideas?
=IF(ISERROR(MATCH(N21,O21:O57,0)),"Not A Full Match","Match")
I'm trying to figure out a way to do a simple data check. I have two rows of data, both have the exact same numbers/Text If one of the numbers/Text changes i need it to post a text of "Not A Full Match" if both data sets a equal i need it to say "Match". The formula I'm currently using works, but it only works for 1 value. I need it to work for an array of data. Any ideas?
=IF(ISERROR(MATCH(N21,O21:O57,0)),"Not A Full Match","Match")