Finding, searching, lookingup a value

[evjatar]

I have column A with 8000 text values (8000 rows) (e.g., RARUS03; RARUS43;etc.).
I have column C with 1500 text values (list of titles that may or may not include values equivalent to the text value in column A)(e.g., "Qualification of the RARUS03 Server", "Checklist for the RARUS43 Server").

What formula can I use for each of the 8000 text values in column A to check their presence as part of the text values listed in column C?

 

[Al Chara]

See the following setup:

Book1
	A	B	C	D
1	RARUS03	TRUE	QualificationoftheRARUS03Server
2	RARUS43	TRUE	ChecklistfortheRARUS43Server
3	RARUS44	FALSE	ChecklistfortheRARUS43Server
Sheet1

You can also use FIND in place of SEARCH. The difference is that FIND is case sensitive and does not allow wild card characters (per the help file).
_________________
Hope this helps.
Kind regards,<font size="5">^{<span style="text-decoration: overline">AL</span>}<u>_CHARA</u></font>
This message was edited by Al Chara on 2002-07-28 11:35

 

[Yogi Anand]

Hi Al Chara:

I was wondering about your searching for the cell A1 value in the corresponding cell C1 only -- my hunch is that the search may have to be conducted in the entire list in column C -- what do you think?

If the search has to be conducted in the entire list in column C, then one of the ways will be to use an array formula like the one in the following simulation:

Book1
	A	B	C	D
1	RARUS03	TRUE	ChecklistfortheRARUS03Server
2	RARUS43	TRUE	ChecklistfortheRARUS43Server
3	RARUS44	TRUE	ChecklistfortheRARUS46Server
4	PARUS04	FALSE	ChecklistfortheRARUS44Server
5	RARUS45	FALSE	ChecklistfortheRARUS07Server
6	PARUS05	FALSE	ChecklistfortheRARUS44Server
7	RARUS46	TRUE	ChecklistfortheRARUS46Server
8	PARUS06	FALSE	ChecklistfortheRARUS44Server
9	RARUS47	FALSE	ChecklistfortheRARUS43Server
10	RARUS03	TRUE
11	RARUS07	TRUE
12	PARUS08	FALSE
13	RARUS44	TRUE
Sheet4

Perhaps the OP can shed some more light on what the real requirements are.

Regards!

Yogi Anand

 

[Al Chara]

Good point Yogi. That situation didn't even cross my mind. But you are probably right.

Note: the following formula is the same thing: =COUNT(SEARCH(A1,$C$1:$C$9,1))>0
You don't need the IF formula.

Al
This message was edited by Al Chara on 2002-07-28 16:32

 

[Yogi Anand]

Hi Al:

Thanks buddy ... for removing some redundant keystrokes.

Regards!

Yogi Anand