Forum Discussion
Zkgabriel
Jan 06, 2019Copper Contributor
Vlookup help
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.
- Hi. Try naming b2 and referencing the name instead. Or lookup index match formula which is a really handy alternative to a vlookup. I hope this helps.
Thanks
- seall12Copper ContributorHi. Try naming b2 and referencing the name instead. Or lookup index match formula which is a really handy alternative to a vlookup. I hope this helps.
Thanks