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

On Nov 12, 4:09 pm, "ragtopcaddy via OfficeKB.com" <u9289@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1