Sort "database" = loose links from other worlsheets??
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
-----Original Message-----
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
.
|