Home

Vlookup Syntax Within Formatted Table / Structured Reference

%3CLINGO-SUB%20id%3D%22lingo-sub-294828%22%20slang%3D%22en-US%22%3EVlookup%20Syntax%20Within%20Formatted%20Table%20%2F%20Structured%20Reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294828%22%20slang%3D%22en-US%22%3E%3CP%3EAFternoon%20all%2C%20need%20help%20on%20syntax%20with%20Vlookups%20across%20two%20separate%20tables%20within%20the%20same%20workbook%20-%20text%20of%20my%20formula%20below%20-%20please%20let%20me%20know%20if%20any%20further%20info%20is%20needed%3A%3C%2FP%3E%3CP%3EFor%20referece%3A%20the%20vlookup%20is%20on%20a%20table%20named%20%22Etran%22%20(within%20a%20sheet%20labelled%20%22Etran%22)%2C%20the%20data%20i%20am%20trying%20to%20pull%20back%20is%20on%20a%20table%20labelled%20%22Assembly%22%20(on%20a%20sheet%20named%20Assembly).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20see%20what%20is%20causing%20errors%20with%20this%20syntax%20below%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(%5B%40%5BUnit%20%2B%20Pt%5D%5D%2CAssembly%5B%40%5BUnit%20%2B%20Pt%5D%5D%3AAssembly%5B%40%5BIplan_ID%5D%5D%2C30%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EJoe%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-294828%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EStructured%20Reference%20Tables%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESyntax%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-294864%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20Syntax%20Within%20Formatted%20Table%20%2F%20Structured%20Reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-294864%22%20slang%3D%22en-US%22%3E%3CP%3EJoe%2C%20you%20did%20not%20mention%20what%20the%20error%20is.%3C%2FP%3E%3CP%3EMy%20guess%20would%20be.%3C%2FP%3E%3CPRE%3E%3DVLOOKUP(%5B%40%5BUnit%20%2B%20Pt%5D%5D%2CAssembly%5B%5BUnit%20%2B%20Pt%5D%5D%3AAssembly%5B%5BIplan_ID%5D%5D%2C30%2C0)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
JoeCavasin
Occasional Contributor

AFternoon all, need help on syntax with Vlookups across two separate tables within the same workbook - text of my formula below - please let me know if any further info is needed:

For referece: the vlookup is on a table named "Etran" (within a sheet labelled "Etran"), the data i am trying to pull back is on a table labelled "Assembly" (on a sheet named Assembly).

 

Can anyone see what is causing errors with this syntax below?

 

=VLOOKUP([@[Unit + Pt]],Assembly[@[Unit + Pt]]:Assembly[@[Iplan_ID]],30,0)

 

Thanks!

Joe

 

1 Reply
Highlighted

Joe, you did not mention what the error is.

My guess would be.

=VLOOKUP([@[Unit + Pt]],Assembly[[Unit + Pt]]:Assembly[[Iplan_ID]],30,0)

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies