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...

Last Name	Vote?
Smith
Johnson
Jones

<tbody>
</tbody>

And some data that looks like this...

Name	Yes	No
John Smith	x
Rev Dr Johnson		x
Fred Jones	x

<tbody>
</tbody>

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

Last Name	Vote?
Smith	Yes
Johnson	No
Jones	Yes

<tbody>
</tbody>

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