# 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
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by ConnectWise

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author 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.