J
Julien Bouvier
Hi, I am trying to use VLOOKUP to find data in a table named: PartsTable. I
want to reference the column using a structured reference. I want to look in
column 4, which is the Weight column:
this works fine: VLOOKUP(//a part number//,PartsTable,4,FALSE)
this wont work: VLOOKUP(//a part number//,PartsTable,PartsTable[Weight],FALSE)
it returns #VALUE! and the VLOOKUP is on the same sheet as the PartsTable
I find it strange that this doesnt work as the automatic filling tool shows
all column headers when I write "PartsTable[". The syntax seems quite
logical. Thank you for your help!
want to reference the column using a structured reference. I want to look in
column 4, which is the Weight column:
this works fine: VLOOKUP(//a part number//,PartsTable,4,FALSE)
this wont work: VLOOKUP(//a part number//,PartsTable,PartsTable[Weight],FALSE)
it returns #VALUE! and the VLOOKUP is on the same sheet as the PartsTable
I find it strange that this doesnt work as the automatic filling tool shows
all column headers when I write "PartsTable[". The syntax seems quite
logical. Thank you for your help!