Forum Discussion

Zkgabriel's avatar
Zkgabriel
Copper Contributor
Jan 06, 2019

Vlookup help

Hello all, so i'm currently working with the following table:

 

 

 ab
1AmountWeight
2Code"Enter here"
3%Weight
40.99823
51.99636
62.99453
73.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
  • seall12's avatar
    seall12
    Copper Contributor
    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

Resources