Hi Greg, You could take the concatenate expression out and put it in one cell , then replace it with an absolute reference to the new location. tc
> OOo 2.0/ win98se. > I'm building a spreadsheet with multiple sheets, one of which(words) > is columns of lists of words that if they partially match a cell > (F489) in the 'master sheet', the total amount in (2)other cells (J&H > 489) is copied to THIS cell. > The formula is cumbersome. I'd like to make it simpler. > ------ > =IF(ISERR(SEARCH(CONCATENATE($words.$S$3; > "|";$words.$S$4;"|";$words.$S$5;"|";$words.$S$6; > [snip] > ;$words.$S$17) > ;F489));"";J489+H489) > > I want to leave the cell blank if no match. > This formula is used in all cells from R6 thru AC1092, so reducing the > size will allow a faster load(i believe). > -- > -- > Greg Agent 1.93/32.576 Opera8.5 OOo2.0 Eudora7 > news.readfreenews.net & news.gmane.org Win98se > for sale: Apple//,Auto Parts/Equip/Manuals: > geardocATgeardoc36DOThostingisfreeDOTcom > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
