Sorting loses links to data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SueD - 09 May 2006 11:06 GMT

In Office 2000, I have links to cells in an Excel list. When the list is
sorted, the links remain to the cell references, so show different data. I
want the links to follow the data when it is sorted, so I guess I somehow
need to link to data and not cells.

Reply to this Message

Bill Manville - 16 May 2006 00:50 GMT

Assuming that there are unique values in one of the columns of the
table that you could use to find the value you want, you need to use a
VLOOKUP formula (if the column of unique values is on the left) or a
combination of INDEX and MATCH (if it is not).

If this is not sufficient to help you, please give an example of what
the source table contains and say which value you want to access by a
formula

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

SueD - 16 May 2006 09:04 GMT

Thank you for your suggestion, but I have subsequently solved the issue by
adding a column to identify the data and then using the SUMIF formula to pick
out the required items.

> Assuming that there are unique values in one of the columns of the
> table that you could use to find the value you want, you need to use a
[quoted text clipped - 8 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message