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.a...tions/200711/1