Vlookup and "-" negative numbers are giving me a #N/A
If I use
=VLOOKUP(B5,Capacity,2)
with 3233 in B5
I get phd4, not good?
--
Regards,
Peo Sjoblom
Portland, Oregon
"DMB" wrote in message
...
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"
|