VLOOKUP with Structured Reference to Table Header
Sorry Julien
I totally misread your posting.
Ignore my response
--
Regards
Roger Govier
"Julien Bouvier" wrote in message
...
Are you suggesting I should use a pivot table instead of an ordinary
table?
"Roger Govier" wrote:
Hi Julien
I take it you are using XL2007.
The same syntax does not apply to Pivot Tables, as it does to Tables.
Tale a look at the GetPivotdData function.
--
Regards
Roger Govier
"Julien Bouvier" wrote in
message
...
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!
|