Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Vlookup(Match) formula in Excel

Posted on 2014-02-10
Medium Priority
730 Views
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
Question by:nmolliconi

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 39848549
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

Author Closing Comment

ID: 39848564
Thank you Barry.  Worked great!

Nick
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
###### Suggested Courses
Course of the Month12 days, 23 hours left to enroll