View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MAJones MAJones is offline
external usenet poster
 
Posts: 5
Default 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?