I am trying to compare cells D4 - I4 with cells in K4 - P4. If one of the cells in D4 - I4 matches the cell that is marked in K4 - P4 it will record a HIT in C4.
If the cells in D4 - I4 does not make a match with the cells in K4 - P4 it will return a MISS in C4.
If there is no data in D4- I4 and K4 - P4 it will show a blank in C4.
I was on another site and they were very helpful, but I could not upload my spreadsheet. When I tried their suggestions I just keep getting a #VALUE! error. Thanks for your help.
Bookmarks