Array search

[JonathanG]

Hi!

I'm trying to write a function for each item in a list to compare if it's in an array, and then write Yes or No, in the box next to the name. The hard part is the names don't line up perfectly.

I have a table that looks like this...[TABLE="width: 500"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]Vote?[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


And some data that looks like this...

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rev Dr Johnson[/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Fred Jones[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And I want to output a table that looks like this...

[TABLE="width: 500"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]Vote?[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

But I'm rusty at which formula to use. I was thinking of an IF() or a LOOKUP(), but I'm not sure on the search syntax, since the names don't line up perfectly. Is it easier to use an array function on this?

Any advice appreciated

Excel 2003