Getting a NA# on a vlookup(match) formula within excel (see attached document). The formula: =IF(VLOOKUP(B1,'DATA INPUT'!$A$2:$I$346,MATCH(SUMMARY!A2,'DATA INPUT'!$A$2:$I$346,0),FALSE)=0,"",(VLOOKUP(B1,'DATA INPUT'!$A$2:$I$346,MATCH(SUMMARY!A2,'DATA INPUT'!$A$2:$I$346,0),FALSE)))
Hello Nick, which figures are you trying to return? If you want the percentages then try this formula in B2 copied across and down....and custom format as 0.00%;; so that zero values are not displayed
=SUMPRODUCT(($A2='DATA INPUT'!$B$3:$B$45)*(B$1='D
see attached
regards, barry
sumproduct.xls