Hello all, so i'm currently working with the following table:
| | a | b |
| 1 | Amount | Weight |
| 2 | Code | "Enter here" |
| 3 | % | Weight |
| 4 | 0 | .99823 |
| 5 | 1 | .99636 |
| 6 | 2 | .99453 |
| 7 | 3 | .99103 |
and using : =VLOOKUP(b2,A4:B7,2,FALSE)
The problem i'm facing is that i cannot seem to enter the amounts from Column B to get the results i want (This table when its done will go from 0-100 the only result i'm getting is #n/a (i seem to be able to bounce it backwards if i set the "2" to "1" i've also tried using TRUE instead of false.
but i'd like to be able to build a table where i enter in any number from column B.
