VLOOKUP #REF Error

[vba317]

I am working in excel 2007. I have set up a Hlookup statement that is not working. I have data in Column A, I need this column to compare to column P. The formula is in column I. The value I want in Column I is the value from column R.

Any help is appreciated
Tom

=VLOOKUP(A2~P2:P17000~17~FALSE)

 

[SkipVought]

Hi,
[tt]
=Index(R2:R17000,Match(A2,P217000,0),1)
[/tt]
Btw, vlookup requires the lookup Column to be the leftmost column in the lookup range.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Larena]

This should work. You need to look in columns P to R and return a value from the third column in that range.

=VLOOKUP(A2,P2:R17000,3,FALSE)