VLookup and Named Ranges
Back again!
This resolved my first issue
=Vlookup(Sheet1!B19,Sheet2!A:B,2,FALSE)
While in Sheet3, this looks up value from Sheet1!B19 and finds it in column A
of Sheet2! returning number from Column B of Sheet2 at corresponding point...
Which for my workbook translated to
=VLOOKUP('ITEM ADD-CHG Form'!W19,'Prod Mktg Summary'!B$4:C$555,2,FALSE)
Now I've been told that instead of calling out the range, I should have referenced the "Named Range" of PLINE
When I modify the formula to
=VLOOKUP('ITEM ADD-CHG Form'!W19,=PLINE,2,FALSE)
I get an error. (The name that you entered is not valid...) I've double checked, it is a valid named range.
Can I get a VLookup formula to do what I'm trying to do?
Thanks!!
Last edited by amthyst826; 02-18-2010 at 08:00 PM.
Take out the second = sign.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
It returns #REF!
=VLOOKUP('ITEM ADD-CHG Form'!X19,PLINE,2,FALSE)
Delete PLINE, with your cursor in that position in the formula press F3 and select the range from the Name box. See if that works better.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Same result #REF!
Well, then, there's your answer. Your named range does not properly function in a lookup. Check the name definition and make sure it is at least two columns wide.
If you can't figure it out, click GO ADVANCED and use the paperclip icon to post up your workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
You are awesome! That was it.
I thought I defined B4 through C555, but only had B4 through B555
Thank you so much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks