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