Thanks, I did this: in "Main"(sheet1) cell R6: =IF(ISERR(SEARCH($words.R$2;$F6));"";$J6+$H6)
in "words"(sheet2) cell R2: =CONCATENATE(R$3;"|";R$4;"|";R$5; [snip] "|";R$21) Works great!!!! On Thu, 19 Jan 2006 10:28:17 -0600 (CST), [EMAIL PROTECTED] wrote: >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] >> >> -- Greg Agent 1.93/32.576 Opera8.5 OOo2.0 Eudora(NG7)6.2.5.6 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]
