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)
Joe, you did not mention what the error is.
My guess would be.
=VLOOKUP([@[Unit + Pt]],Assembly[[Unit + Pt]]:Assembly[[Iplan_ID]],30,0)