SarnovaHCLLC
New Member
- Joined
- Sep 23, 2016
- Messages
- 2
I am not getting the results from the formulas as expected.
One returns the correct data but still leaves the dreaded #N/A if no match is found.
=IF(ISNA(MATCH($A:$A,4-8-16,0)),(VLOOKUP($A:$A,'04-08-16'!$A:B,2,FALSE)))
The other returns all 0's.
=IF(ISNA(MATCH($A:$A,4-8-16,0)),0,(VLOOKUP($A:$A,'04-08-16'!$A:B,2,FALSE)))
One returns the correct data but still leaves the dreaded #N/A if no match is found.
=IF(ISNA(MATCH($A:$A,4-8-16,0)),(VLOOKUP($A:$A,'04-08-16'!$A:B,2,FALSE)))
The other returns all 0's.
=IF(ISNA(MATCH($A:$A,4-8-16,0)),0,(VLOOKUP($A:$A,'04-08-16'!$A:B,2,FALSE)))