Updating a value using match

[RoccoM]

Column X contains a list of all companies.
Column Y is used for a simple check (values would be yes, no, n/a)
In column Z I have a partial list of company names.

Here is what I need help with:
I need to start at Cell z2 see if that value matches ANY value in my column X Range (x1:x1000)
If yes I need to update value in column b with a yes

How can I do this?

Thank you in advance.

 

[MPaul100]

Something like =if(not(iserror(vlookup(z2,$X$1:$X$1000,1,0))),"yes","no")

 

[Toadstool]

Maybe...

	B	W	X	Y	Z
1	Update Here		Company List	Simple Check	Partial List
2	yes		White Sky Inc.	yes	ACME Widgets
3	yes		Easy Partners	no	Ivor Leake, Plumber
4			ACME Widgets	n/a
5			Hope & Sky Inc.	yes
6			Lawyers Soo, Grabbitt & Runn	no
7			Ivor Leake, Plumber	n/a

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

RoccoM​

Worksheet Formulas Cell Formula B2 =IF(ISNA(MATCH(Z2,$X$2:$X$1000,0)),"","yes") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[RoccoM]

Team:
I didn't explain my self correctly. But based on your answers to my question, I'm so close I could taste it.

It is important where the yes answer goes.

If a value in a cell in column Z matches a value in column X then I need the column Y to say yes for the corresponding value of X.
For example:

I find Acme Widgets in my full list of companies in column X, I then update the simple check column, column, Y next to Acme Widgets with Yes

		X	Y	Z
1		Company List	Simple Check	Partial List
2		White Sky Inc.		ACME Widgets
3		Easy Partners		Ivor Leake, Plumber
4		ACME Widgets	Yes
5		Hope & Sky Inc.
6		Lawyers Soo, Grabbitt & Runn
7		Ivor Leake, Plumber	Yes

<tbody>
</tbody>

I hope this makes more sense?
Rocco

 

[Toadstool]

Is this it?

	X	Y	Z
1	Company List	Simple Check	Partial List
2	White Sky Inc.		ACME Widgets
3	Easy Partners		Ivor Leake, Plumber
4	ACME Widgets	yes
5	Hope & Sky Inc.
6	Lawyers Soo, Grabbitt & Runn
7	Ivor Leake, Plumber	yes

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

RoccoM​

Worksheet Formulas Cell Formula Y2 to Y1000 =IF(ISNA(MATCH(X2,$Z$2:$Z$1000,0)),"","yes") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[RoccoM]

Perfect!
I was just overthinking it!
Thank you!
Rocco