Vlookup unusual results!

[John P]

Hi,

In Excel 2003 Win XP Pro - I am trying to reuse the result of
=VLOOKUP(M159,Players,4) which returns a name into cell K160.

I then want to do a vlookup on that name in =VLOOKUP(K160,A156:A167,1) to
get a value.

Unfortunately the value returned is a name 6 rows down from the top of
A156:A167!!!! (Value stored in A162)


Any suggestions as to where I am missing the plot would be gratefully
received.


Cheers from a very wet North Yorkshire UK


John P

 

[Frank Kabel]

Hi
try:
=VLOOKUP(K160,A156:A167,1,0)

 

[Rita Palazzi]

Frank,
Why the "0" as opposed to "True" or "False"? I always use "False" to
get an exact match. What does "0" do?
Thanks,
Rita

 

[John P]

Hi Frank

That brings back the original name. I need the value to the right of it
please?

Cheers

John

 

[Gary Hopkins]

Then do:

=VLOOKUP(K160,A156:A167,2,0)

Hi Frank

That brings back the original name. I need the value to the right of it
please?

Cheers

John

 

[John P]

Sadly that returns #N/A

John

Then do:

=VLOOKUP(K160,A156:A167,2,0)

 

[John P]

Sorry I meant #REF

Then do:

=VLOOKUP(K160,A156:A167,2,0)

 

[Frank Kabel]

Hi
0 is the same as FALSE (1 = TRUE). I'm just lazy and avoid typing the
longer string 'False'

 

[Frank Kabel]

Hi
use
=VLOOKUP(K160,A156:B167,2,0)

if your values are in column B. See for VLOOKUP help:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Rita Palazzi]

Is it doing the #REF in all cells? When I use VLOOKUP, I have to keep
the array static so that when I drag the formula down, the array
references don't change. Try this

=VLOOKUP(K160,$A$156:$A$167,2,0)


Hope this helps!

Rita Palazzi
Senior Engineer / GTS Int'l MIS
FedEx Express

 

[John P]

Brilliant Rita

That did it!!!!

Thanks so much.

Best wishes


John
North Yorkshire UK