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

My table is

CAPACITY
0 xxx
1000 phd2
2000 phd3
3000 phd4
4000 phd5
5000 phd6

B5 = 3233
=vlookup(B5, CAPACITY, 1)

And now I get nothing but "xxx"