| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
