Share via

Structured references in Excel

Anonymous
2020-10-09T18:11:57+00:00

Structured references

Example from workbook

=Product_Rates[@[Dec-23 Pi Sell]]*DX187

=Product_Rates!HJ187*DX187

If I drag and drop it does not reflect a change in the value if I make an alteration in the column.

I am pasting the above data from worksheet to another worksheet in the same workbook but as you can see difference. I want as line one,

Can you help please

Best regards

Joe Dunne

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2020-10-09T20:21:04+00:00

    The structured reference only works within the existing table - you could add a column of formulas to your table like

    =[@[Dec-23 Pi Sell]]*Sheet2!DX187

    That syntax basically means use the value from the same row in the field "Dec-23 Pi Sell" to perform the calculation, and really doesn't have meaning outside the table.

    For external references to the table with formulas off sheet, you should use the cell address style.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-10-10T07:39:22+00:00

    Hello Bernie,

    Thank you very much for prompt and helpful reply. I was confused as some references came across automatically.

    Again thanks

    1 person found this answer helpful.
    0 comments