Need help with Lookup
 

I have a file named Names_MAJones. A1:A150 is ID numbers, B1:150 is names.
I need to schedule in another workbook the names in Names_MAJones. I know
everyones names but not their ID. What Formula can I use to type the persons
name and have their ID transfer to the schedule?

Need help with Lookup
 

=INDEX('[Names_MAJones.xls]Sheet1'!$A$1:$A$150,MATCH("name",'[Names_MAJones.
xls]Sheet1'!$B$1:$B$150,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MAJones" wrote in message
...
I have a file named Names_MAJones. A1:A150 is ID numbers, B1:150 is
names.
I need to schedule in another workbook the names in Names_MAJones. I know
everyones names but not their ID. What Formula can I use to type the
persons
name and have their ID transfer to the schedule?

Need help with Lookup
 

Thanks,
This works perfect.
Skip

"Bob Phillips" wrote:

=INDEX('[Names_MAJones.xls]Sheet1'!$A$1:$A$150,MATCH("name",'[Names_MAJones.
xls]Sheet1'!$B$1:$B$150,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MAJones" wrote in message
...
I have a file named Names_MAJones. A1:A150 is ID numbers, B1:150 is
names.
I need to schedule in another workbook the names in Names_MAJones. I know
everyones names but not their ID. What Formula can I use to type the
persons
name and have their ID transfer to the schedule?