Comparing databases and returning values
 

Hello,
I would like to write a worksheet function which compare the contents in two
cells at the same time from a database1 with the contents in two columne in
database2.
Whenever there is a match I would like it to return a a prespecified text
(i.e Yes or No) and a value from database2 associated with the found match
in different cells of database1.

Empty cells in database1 (in one or both the cells where comparasions values
are found) also needs to be considered as no comparasion should be made (i.e.
do not return the text Yes/No for the first match with any empty cell in
database2).

Anyone that has suggestions?

Kind regards
Jonas