Solved

Excel 2007 - Using VLOOKUP to autofill column

Posted on 2012-03-12
2
336 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 150 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now