SOLVED
Home

Vlookup help

%3CLINGO-SUB%20id%3D%22lingo-sub-309342%22%20slang%3D%22en-US%22%3EVlookup%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309342%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%20so%20i'm%20currently%20working%20with%20the%20following%20table%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Ea%3C%2FTD%3E%3CTD%3Eb%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EAmount%3C%2FTD%3E%3CTD%3EWeight%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3ECode%3C%2FTD%3E%3CTD%3E%22Enter%20here%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%25%3C%2FTD%3E%3CTD%3EWeight%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E.99823%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E.99636%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E.99453%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E.99103%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20using%20%3A%26nbsp%3B%3DVLOOKUP(b2%2CA4%3AB7%2C2%2CFALSE)%3C%2FP%3E%3CP%3EThe%20problem%20i'm%20facing%20is%20that%20i%20cannot%20seem%20to%20enter%20the%20amounts%20from%20Column%20B%20to%20get%20the%20results%20i%20want%20(This%20table%20when%20its%20done%20will%20go%20from%200-100%20the%20only%20result%20i'm%20getting%20is%20%23n%2Fa%20(i%20seem%20to%20be%20able%20to%20bounce%20it%20backwards%20if%20i%20set%20the%20%222%22%20to%20%221%22%20i've%20also%20tried%20using%20TRUE%20instead%20of%20false.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20i'd%20like%20to%20be%20able%20to%20build%20a%20table%20where%20i%20enter%20in%20any%20number%20from%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309347%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309347%22%20slang%3D%22en-US%22%3EHi.%20Try%20naming%20b2%20and%20referencing%20the%20name%20instead.%20Or%20lookup%20index%20match%20formula%20which%20is%20a%20really%20handy%20alternative%20to%20a%20vlookup.%20I%20hope%20this%20helps.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E
Zkgabriel
New Contributor

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.

  

1 Reply
Solution
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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies