I can't find vlookup values!

[ragtopcaddy via OfficeKB.com]

I must be dense! I can't understand any of the explanations of vlookup that I
find anywhere.

I have a unique ProductID in column A of a spreadsheet named "Combined". I
have a named range, "RepoData" on a spreadsheet named "Repo", which includes
the same value in its column A, as column A of "Combined". I'm looking right
at the value I want to return which is in column C of "Repo". Yet when I put
the following formula in column AG of "Combined", I get "#N/A". What am I
doing wrong?

=VLOOKUP(A4,RepoData,3,FALSE)

A4 is ProductID on "Combined"
RepoData is the named range on "Repo"
ProductID is in column A of RepoData
I'm looking right at the correct matching product ID for the row in "Repo"
The value in column C in RepoData is not returned.

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1

 

[Pete_UK]

It has to be an exact match, so perhaps your ProductID contains
"numbers" that are really text values, and the content of A4 is a
proper number. Try changing your formula to:

=VLOOKUP(""&A4,RepoData,3,FALSE)

to test it out.

Hope this helps.

Pete

 

[Jock]

Make sure that columns A to C are included in your "Repodata" range.
If that doesn't work, try replacing the named range with the sheet name
instead.
=VLOOKUP(A4,'Repo'!A1:C50,3,FALSE)

 

[ragtopcaddy via OfficeKB.com]

Thanks to both of you for your suggestions. Jock had it right. Due to
programmer error ;-) column A was not getting selected during the named range
creation. Now it is, and the vlookup works just fine.

Thanks,

Bill

Make sure that columns A to C are included in your "Repodata" range.
If that doesn't work, try replacing the named range with the sheet name
instead.
=VLOOKUP(A4,'Repo'!A1:C50,3,FALSE)

I must be dense! I can't understand any of the explanations of vlookup that I
find anywhere.

[quoted text clipped - 13 lines]

I'm looking right at the correct matching product ID for the row in "Repo"
The value in column C in RepoData is not returned.