Lookup function-text

[T.Mad]

Hi there
I have a query about the lookup function.
In one column there are registered the names of some people and in a second
column there are registered the ages of these people. In another cell I have
a part of the names list and I want to use the lookup function to find the
age of these people. The example is illustrated below:

mary 33 peter =LOOKUP(C1;$B$1:$B$8;$A$1:$A$8)
peter 44 mary =LOOKUP(C2;$B$1:$B$8;$A$1:$A$8)
john 65 ted =LOOKUP(C3;$B$1:$B$8;$A$1:$A$8)
ted 43
mario 30
marco 20
george 16
michael 35


Although the formula seems to be ok I am getting a “N/Aâ€. Can you please
give me a good piece of advice?

 

[T.Mad]

SORRY FOR THE PREVIOUS POST BUT THERE IS A CORRECTION IN THE FORMULAS. I ALSO
WANT TO ADD THAT I USE TEXT WITH GREEK CHARACTERS

 

[T.Mad]

correction AS DESCRIBED PREVIOUSLY IN THE FUNCTION