View Single Post
 
Old 03-25-2012, 07:50 AM
MarvinP MarvinP is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2012
Location: Seattle, WA
Posts: 12
MarvinP is on a distinguished road
Default

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.
Reply With Quote