View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Vlookup and "-" negative numbers are giving me a #N/A

Make sure that the first column in Capacity is a real number
select an empty cell
edit|copy
select that first column
edit|Paste special|check add.

Then try it again.

If that doesn't work, what is Capacity defined as--just share the address of
that table.

DMB wrote:

I figured out that the column numbers are relitive to the table and not the
sheet. I also found that the result is the row before the next higher value.
ROW1 ROW2 ROW3
CAPACITY HOLDOWN
0 n.r.
1000 PHD1
2000 PHD2
3000 PHD3
4000 PHD4

=VLOOKUP(1500, CAPACITY, 3) RETURNS A BLANK
=VLOOKUP(1500, CAPACITY, 2) RETURNS n.r.

tHE NEGATIVE PROBLEM SEEMS TO HAVE GONE AWAY. Is the return value working
correctly? I am going to experiment with the true/false value. The problem
with this is anyone entering data will be confused by the table.


--

Dave Peterson