Vlookup Question

[Tennisguuy]

I want to have excel look up a value in a chart and if the value is in the chart I want excel to say either Yes the value is there or No the value isn't.

For example,

Chart

A B C
1 Date Check Number Amount
2 1/1/2010 100 $200
3 2/1/2010 101 $300
4 3/3/2010 102 $400

If the lookup check number is 100 I want excel to return Yes the check is in chart.

If the lookup check number is 104 I want excel to return No the check is not in the chart.

 

[VoG]

Like this?

Excel Workbook
	A	B	C	D	E	F
1	Date	Check	Amount		100	Yes
2	01/01/2010	100	$200		104	No
3	02/01/2010	101	$300
4	03/03/2010	102	$400
Sheet5

 

[Tennisguuy]

Yes that worked. Thanks alot.