Hi. I have a list of unique numbers in a range i.e. A1A15. I need to check if each number exists in another range, with unique number i.e. E1:L1. By unique numbers, I mean that the number won't be expressed again in that range - there's only one of that number. If the number is found, for the value to be expressed as 1 and if not, to be expressed as 0.
I've used 'match' and 'lookup', however I keep encountering '#N/A' if the number is not found. The '#N/A' interferes with percentage calculations I'm using to generate a score. What am I missing, or is there another formula that I should be using?