Searching for specific text - how to
 

I have a master spreadsheet of 850 names (col A) and associated unique
user ids (col B) which are all linked to other spreadsheets specific
to each person. I would like to be able to add a search function to
the master spreadsheet so I can simply enter a persons name or ID and
jump to the corresponding cell in the master spreadsheet or have the
linked spreadsheet open. Can anyone offer a simple solution? Thanks in
advance.