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))
Labels:
Excel
Sort of technology related, but other stuff too