Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2007 - Using VLOOKUP to autofill column

Posted on 2012-03-12
2
Medium Priority
?
363 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
New style of hardware planning for Microsoft Exchange server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

688 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