If nested with Vlookup

[SarnovaHCLLC]

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)))

 

[arthurbr]

The syntax in your formulas is not correct
Both should search for one value in a range
What is MATCH($A:$A,4-8-16,0) supposed to do ?
VLOOKUP also searches for one value in a range but both your search values are ranges????

 

[SarnovaHCLLC]

I have found a formula that has resolved my issue.[TABLE="width: 147"]
<colgroup><col width="196" style="width: 147pt; mso-width-source: userset; mso-width-alt: 3584;"> <tbody>[TR]
[TD="class: xl65, width: 196, bgcolor: transparent"]=IFNA(VLOOKUP($A:$A,'04-08-16'!$A:$B,2,FALSE),0)[/TD]
[/TR]
</tbody>[/TABLE]