Hi all,

I need this function to deal with thousands of records. Please give me
a hand. Thank you very much.
I would simplify my problem to the following question.
Say I have a column A and B in sheet1, A1=fdhjsa, A2=rieqrew,
A3=mxnvvc,..., A10=rewkjrk. Now I want to set a judgment to
corresponding B cell, if "fdhjsa"(A1) exist in sheet2!$A$1:$Z$500, then
B1="yes", else B1="no", if "rieqrew"(A2) exist in sheet2!$A$1:$Z$500,
then B2="yes", else B2="no"... and so on.
One more question, could I set B2 a color instead of a value of "yes"
or "no"? For example, if "fdhjsa"(A1) exist in sheet2!$A$1:$Z$500, cell
B2 will set to be yellow, else B2 will set to be red.
Any information would be appreciated.

Best, zh

=IF(COUNTIF(Sheet2!$1:$65536,Sheet1!A1)0,"Yes","N o")

use conditional formatting, and test for a value of Yes

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hi all,

I need this function to deal with thousands of records. Please give me
a hand. Thank you very much.
I would simplify my problem to the following question.
Say I have a column A and B in sheet1, A1=fdhjsa, A2=rieqrew,
A3=mxnvvc,..., A10=rewkjrk. Now I want to set a judgment to
corresponding B cell, if "fdhjsa"(A1) exist in sheet2!$A$1:$Z$500, then
B1="yes", else B1="no", if "rieqrew"(A2) exist in sheet2!$A$1:$Z$500,
then B2="yes", else B2="no"... and so on.
One more question, could I set B2 a color instead of a value of "yes"
or "no"? For example, if "fdhjsa"(A1) exist in sheet2!$A$1:$Z$500, cell
B2 will set to be yellow, else B2 will set to be red.
Any information would be appreciated.

Best, zh