Search This Blog

Friday 21 May 2010

Excel: Prevent VLOOKUP from showing N/A

=IF(ISNA(VLOOKUP($A12,'MIS Data'!$A$2:$AK$74,21,FALSE)),0,VLOOKUP($A12,'MIS Data'!$A$2:$AK$74,21,FALSE))