This will probably also work and is shorter (but maybe not faster, I don't
know):
in "Main"(sheet1) cell R6:
=IF(ISERR(SEARCH($words.R$2;$F6));"";$J6+$H6)
in "words"(sheet2) cell R2:
=R$3&"|"&R$4&"|"&R$5&
[snip]
"|"&R$21
Johnny
Den 2006-01-21 02:36:26 skrev GregChi <[EMAIL PROTECTED]>:
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]
--
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
