On Sun, 30 Mar 2008 14:22:00 -0700, amy howell
wrote:

I am trying to enter a formula into cell that included the VLOOKUP function
and I keep getting an N/A error as my result. Why would it do this, and what
can I do to ensure I don't keep getting it?

I am in worksheet and I am basically trying to reference another worksheet
for some of the values. I enter C3 as my lookup value (in existing sheet); I
enter a range reference (from another worksheet) as my table array; I enter
the number 2 because that is column (from the another worksheet) that I want
to use; finally, I enter FALSE because I want to return an exact match). I
also have to multiply the lookup value by C4 (in existing sheet).

Any advise is greatly appreciated. Thanks.
Amy


It would be easier if you copied the formula that gave the N/A error.

Make sure that the range that you refer to includes also the second
column. If not, that would be one source of the N/A error.

Hope this helps / Lars-Åke