match a name and return a tel number?
 

I am trying to match a list of names to return a number.
I have tried an IF but I can't nest more than 7
I have tried lookup but it is not anexact match
Match is no good as it gives a relative position
What is the right function/formula for this?
Thanks

match a name and return a tel number?
 

HELPVLOOKUP

"Al" wrote:

I am trying to match a list of names to return a number.
I have tried an IF but I can't nest more than 7
I have tried lookup but it is not anexact match
Match is no good as it gives a relative position
What is the right function/formula for this?
Thanks

match a name and return a tel number?
 

Hi Al,

Take a look at VLOOKUP using all 4 arguments.

HTH
Regards,
Howard

"Al" wrote in message
...
I am trying to match a list of names to return a number.
I have tried an IF but I can't nest more than 7
I have tried lookup but it is not anexact match
Match is no good as it gives a relative position
What is the right function/formula for this?
Thanks

match a name and return a tel number?
 

I think Index/Match did the job. Thanks Al

"Vacation's Over" wrote:

HELPVLOOKUP

"Al" wrote:

I am trying to match a list of names to return a number.
I have tried an IF but I can't nest more than 7
I have tried lookup but it is not anexact match
Match is no good as it gives a relative position
What is the right function/formula for this?
Thanks