View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter atherton Peter atherton is offline
external usenet poster
 
Posts: 1
Default 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
.