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

If the first column of that table is numeric (real numbers) and if b5 is numeric
(real numbers), then I get 3000 back from that formula.

If b5 contains the text '3233, then I get #n/a

Debra Dalgleish has some trouble shooting tips at:
http://www.contextures.com/xlFunctions02.html#Trouble

ps. Did you want to return column 2:
=vlookup(B5, CAPACITY, 2)
(assuming that Capacity is a 2 column table.)

DMB wrote:

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"


--

Dave Peterson