Cook09
asked on
Excel Table Syntax Single Cell
Experts,
Attached is a workbook in which I'm trying to find the syntax for a single Cell. If the Table Name for A1:D8 = MstrTable, then what is the Syntax for A2(D0100) to be placed into G5. This syntax can then be used to copy down to the rest of the rows.
Cook09
Table-lookup.xlsx
Attached is a workbook in which I'm trying to find the syntax for a single Cell. If the Table Name for A1:D8 = MstrTable, then what is the Syntax for A2(D0100) to be placed into G5. This syntax can then be used to copy down to the rest of the rows.
Cook09
Table-lookup.xlsx
As far as I know, there is no function to do that. What you are trying to do is an Offset using a range name instead of a single cell, which does not work.
Instead, use a VLOOKUP.
Instead, use a VLOOKUP.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!! Exactly what I was looking for. After searching all of the ways to reference a Table, none showed how to access a single cell within a Table.
not clear what you want to accomplish, can you input the values that need to be in the cell G5 and other so that formula can be made.