Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel 2007 - Using VLOOKUP to autofill column

Posted on 2012-03-12
2
Medium Priority
?
374 Views
Last Modified: 2012-03-12
I have a worksheet where I have a drop down list and I am trying to auto fill the column to the right. I attached the Excel file. I am having some issue getting the value to populate properly. Could someone please take a look at this and tell me what I am doing wrong?

The field I am testing this on is D27 on the Worksheet tab.

"=IF(ISBLANK(C27),0,VLOOKUP(C27,list,2))"

I keep getting #NAME? but it is suppose to be pulling in the RATE (20) from the tab sheet2.

Thanks!
Dan
Estimator.xlsx
0
Comment
Question by:filtrationproducts
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 600 total points
ID: 37709712
You don't have a range named List, so you actually want:
=IF(ISBLANK(C27),0,VLOOKUP(C27,List!A:B,2,FALSE))
0
 
LVL 1

Author Closing Comment

by:filtrationproducts
ID: 37709754
I see now, thank you!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Though there are a few manual ways to import PST files to Office 365 , third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the to…
Get to Know about Lotus Notes email migration to Office 365 in detail. Explore the article for better Lotus Notes to Office 365 migration techniques to transfer all data items to the O365 domain.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question