Katherine Falin
New Member
- Joined
- Sep 9, 2014
- Messages
- 5
Let me start by saying, I'm new to formulas. I need a vlookup formula to find policy numbers matches. If a match is found then insert a specific date "8/22/2014". If no match is found, leave cell blank. A friend at work gave me this one to try. =IF(VLOOKUP(K3,'Eligible Pol Remailed 8.22'!J:J,1,FALSE)=TRUE,"","8/22/2014")
The formula will insert the date, but I am still receiving the NA error message. Suggestions?
The formula will insert the date, but I am still receiving the NA error message. Suggestions?