Forum Discussion

Zkgabriel's avatar
Zkgabriel
Copper Contributor
Jan 06, 2019
Solved

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 ...
excel
  • seall12's avatar
    seall12
    Jan 06, 2019
    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
Jan 06, 2019
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