Vlookup(Match) formula in Excel

Good Afternoon,

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

Any guidance would be much appreciated.

Thank you
Nick
test-file.xls
nmolliconiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
barry houdiniConnect With a Mentor Commented:
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='DATA INPUT'!$C$2:$I$2),'DATA INPUT'!$C$3:$I$45)

see attached

regards, barry
sumproduct.xls
0
 
nmolliconiAuthor Commented:
Thank you Barry.  Worked great!

Nick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.