Shannon2008
New Member
- Joined
- Oct 22, 2008
- Messages
- 12
I am trying in use the following formula and keep getting a formula error message. I think I have too many or not enough () I want the cell to remain blank if the value is not found in the lookup. Please help.
Thanks.
IFNA((VLOOKUP(A3,PIP,7,FALSE)," ")),(VLOOKUP(A3,PIP,7,FALSE))
Thanks.
IFNA((VLOOKUP(A3,PIP,7,FALSE)," ")),(VLOOKUP(A3,PIP,7,FALSE))