Thread
:
Vlookup and "-" negative numbers are giving me a #N/A
View Single Post
#
4
Posted to microsoft.public.excel.misc
DMB
Posts: n/a
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"
Reply With Quote