Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 735
  • Last Modified:

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
0
nmolliconi
Asked:
nmolliconi
1 Solution
 
barry houdiniCommented:
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now