| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
