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]