texasalynn
Well-known Member
- Joined
- May 19, 2002
- Messages
- 8,458
I have the following formula that works fine when the match exists, but when there is no match I get #N/A.
=IF(MATCH(A10,'JE data'!$A$2:$A$56,0),VLOOKUP(A10,'Revsum data'!$A$2:$K$118,11,FALSE),0)
I need to get rid of this. I tried putting in a ISNA statement in front of the match, but then I get the vlookup information. If the match does not exist I need to return 0.
I hope I have explained this correctly.
Thanks
texasalynn
=IF(MATCH(A10,'JE data'!$A$2:$A$56,0),VLOOKUP(A10,'Revsum data'!$A$2:$K$118,11,FALSE),0)
I need to get rid of this. I tried putting in a ISNA statement in front of the match, but then I get the vlookup information. If the match does not exist I need to return 0.
I hope I have explained this correctly.
Thanks
texasalynn