excel,vlookup
Posted by Dale Mahue on January 29, 2002 12:57 PM
First,I have a formula in col. F that reads, =D3-E3
Then I have a formula in col G that reads,
=vlookup(F3,$N$3:$O$119,2,false)
The ans in G is #n/a.
How can I get these two formulas to work together?
If I enter the result into F ,the lookup feature works,
but when I use the result of the first formula the #n/a comes up
Posted by Mark W. on January 29, 2002 1:00 PM
Make sure your lookup table, $N$3:$O$119, has
an entry in column N for every conceivable
value produced by =D3-E3
Posted by Dale Mahue on January 29, 2002 1:55 PM
Yes it has all the values
Posted by Mark W. on January 29, 2002 3:03 PM
Make sure the values in column N are numeric and
not text values that look like numbers (e.g., "1").
Posted by Chris D on January 29, 2002 3:10 PM
also, check that the value in F is exactly equal to the value you expect to be found in your lookup
for example if the value is 24.9999999999999999 but is showing as 25, it will not be found via lookup if your lookup table contains 24,25,26 etc
as Mark originally suggested, it's conceivable that d3-e3 is not a whole number contained within your vlookup table
I get lots of 18.000000000000001s and 299.99999999999654 in my spreadhseets sometimes, especially after using copy/paste special/values from the results of %age formulae..... grrrrrr, very annoying
hope this helps somewhat
Chris
