Forum Discussion

JoeCavasin's avatar
JoeCavasin
Brass Contributor
Dec 04, 2018

Vlookup Syntax Within Formatted Table / Structured Reference

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

 

Formulas and Functions
Structured Reference Tables
Syntax
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Dec 04, 2018

    Joe, you did not mention what the error is.

    My guess would be.

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

     

Resources