Hi
use VLOOKUP. e.g.
=VLOOKUP(B1,sheet1'!A1:C100,3,0)

"tommie" wrote:

HELP!

I have a spreadsheet with data in it that ranges from A to Q. There are two
sheets that hold info on eachother. I need to be able to type a branch
number into Field B, and the password of the store enters automatically into
feild N both in the first sheet. The data that it needs to get the password
from is on worksheet 2 where i have the branch number in field A and the
password in field C.

PLEASE HELP im going mad!!