We help IT Professionals succeed at work.

Excel 2007 - Using VLOOKUP to autofill column

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
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
You don't have a range named List, so you actually want:
=IF(ISBLANK(C27),0,VLOOKUP(C27,List!A:B,2,FALSE))

Author

Commented:
I see now, thank you!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.