Solved

Excel 2007 - Using VLOOKUP to autofill column

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

735 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