Why is this not working? I added the roundup column because i thought that might be the problem.
=VLOOKUP(0.18,B4:C2819,2,FALSE) result=#N/A
A B C D
GP% roundup profit price
0.35 0.36 $635.00 $1,800.00
0.35 0.36 $630.00 $1,795.00
0.35 0.35 $625.00 $1,790.00
continues
0.19 0.19 $265.00 $1,430.00
0.18 0.19 $260.00 $1,425.00
0.18 0.18 $255.00 $1,420.00
0.18 0.18 $250.00 $1,415.00
0.17 0.18 $245.00 $1,410.00
0.17 0.18 $240.00 $1,405.00
any ideas?
Bookmarks