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 |
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 |
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 . |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com