Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with Structured Reference to Table Header
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a structured reference absolute? | Excel Worksheet Functions | |||
Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
Structured references & Quickbooks data | Excel Worksheet Functions | |||
use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions |