I can't find vlookup values!

  • Thread starter ragtopcaddy via OfficeKB.com
  • Start date
R

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
 
P

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
 
J

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)
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top