Using VLOOKUP wrong?

[Destrachan]

Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.

Here's what I thought the formula should look like:
=VLOOKUP([Number.xls]Sheet1!$A$2:$A$500="JACK",Number.xls!Test,
2,FALSE)

Can someone please point out my idiocy & get me set on the right
track?

Thanks a ton

 

[p45cal]

Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.

Here's what I thought the formula should look like:
=VLOOKUP([Number.xls]Sheet1!$A$2:$A$500="JACK",Number.xls!Test,
2,FALSE)

Can someone please point out my idiocy & get me set on the right
track?

Thanks a ton

The first two arguments of vlookup are (1) the value you're searching
for, then (2) the range that you're searching within. So confirm if you
would, that the value you're searching for is:
[Number.xls]Sheet1!$A$2:$A$500="JACK"
which is a bit suspect to me, and the range you're looking in is:
Number.xls!Test
which I think might be a sheet.

A shot in the dark:
=VLOOKUP("JACK",[Number.xls]Sheet1!$A$2:$B$500,2,FALSE)
?

 

[Destrachan]

Hey all, I've got 2 columns "A" has names & "B" has percentages.  I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.

Here's what I thought the formula should look like:
=VLOOKUP([Number.xls]Sheet1!$A$2:$A$500="JACK",Number.xls!Test,
2,FALSE)

Can someone please point out my idiocy & get me set on the right
track?

Thanks a ton

The first two arguments of vlookup are (1) the value you're searching
for, then (2) the range that you're searching within. So confirm if you
would, that the value you're searching for is:
[Number.xls]Sheet1!$A$2:$A$500="JACK"
which is a bit suspect to me, and the range you're looking in is:
Number.xls!Test
which I think might be a sheet.

A shot in the dark:
=VLOOKUP("JACK",[Number.xls]Sheet1!$A$2:$B$500,2,FALSE)
?

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=170133

Microsoft Office Help

Well, your shot in the dark was dead on. Thanks a bunch I now
fully understand the arguments/parameters and what it was I was doing
wrong...I completely misinterperted what I was supposed to be doing.

And to answer your question, the Number.xls!Test is a named group.
Cells A2:B500 were renamed to Test.