Macro to check data from excel list against access query and return value back to excel

[dreamkeeper]

(I posted this yesterday but am tryign to make it clearer)
I have an excel list with "name" and "title" and there are many erros
and mis-spellings. I havbe an acess quesry that has the correct names
and titles and also some mis-spellings and foreign language spellings
pointing to the correct english name and title.

I would like to write a macro in excel to do a lookup of the excel
value in the access quesry and find EITHER an exact match or close
match and return the value of a specified field back into an excel
column.

Here is a hypothetic example:
Access list:
PK=Van Gogh, Vincent
vangogh
VanGogh
Van Go

PK= Starry night, c1889
starrie night
starry nite
french for starry night

Excel list
vangogh
starry nite

I want to do a look up in access. from excel. of both the name and the
name combined with the title and return the correct value back into
excel in a blank column:
lookup:
vangogh
vangogh, starry nite

return:
Van Gogh, Vincent
Starry Night, 1889

I can do a look up that wil return a close match but do not knwo how
to do a look up of combined fields liek name and title to search
access name and title and return a single value. PLus try to write a
macro to do it.

I am stumped.