Need help with Lookup

M

MAJones

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?
 
B

Bob Phillips

=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)
 
M

MAJones

Thanks,
This works perfect.
Skip

Bob Phillips said:
=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 said:
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?
Click to expand...
Click to expand...
 
Top