VLOOKUP with Structured Reference to Table Header
VLOOKUP fails because it expects an integer.
Table1[Weight] is an array of data.
In place of the column index number (4), you can use this:
COLUMN(Table1[Weight])-MIN(COLUMN(Table1))+1
(if you are desperate)
Otherwise you might consider this formula:
=INDEX(Table1[Weight],MATCH(Target,Table1[PN],0))
|