Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort "database" = loose links from other worlsheets??
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort "database" = loose links from other worlsheets??
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 Nuno wrote in 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing sort ascending or descending when go into "data" "sort"? | Excel Discussion (Misc queries) | |||
How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |