Sort "database" = loose links from other worlsheets??

[Nuno]

Hi guys.

After o SORT a "database" in a worksheet in excell the
formulas in other worksheets that point to a specific
cell in a record, doens´t follow that change, and become
useless(wrong record!)

how can i meke htis work??

Thnaks
Nuno

 

[Tom Ogilvy]

If the data has a column of values that can be used to identify the row
required, you can use a lookup formula to retrieve values.

see help on
Vlookup
Lookup

and Index and Match.

Regards,
Tom Ogilvy

Hi guys.

After o SORT a "database" in a worksheet in excell the
formulas in other worksheets that point to a specific
cell in a record, doens´t follow that change, and become
useless(wrong record!)

how can i meke htis work??

Thnaks
Nuno

 

[Peter atherton]

Hello Nuno

I inserted a column of unique numbers 1 to n on both sheets
and used this formula.

=INDEX(Table,MATCH(A13,Index,0),3)

Table is the list of data including the numerical index.

3 is the offset value

If you want to perform some calculation after finding the
value try say

=INDEX(Table,MATCH(A13,Index,0),3)* 17.75%

Regards
Peter