Hi wrighty50,
Pecoflyer didn't like the "False" because the MATCH() function is looking for a -1,0 or 1 for the third argument. Your "False" in your CF formula will translate to a zero and all if fine for an exact match. So you can use a zero or False in your case.



I'll look at your new attach file now but wanted to get the False vs Zero partial question answered first.

Hi MarvinP,

ok thanks, so my formula regarding the FALSE is ok then, and yes I'm only dealing with exact matches for the data validation, so should be fine on that front.

Yes much appreciated if you could now look at my revised example

Thanks