Help with lookup

I have names of people with their information to the right of their name:

a b c d

john 25 89898 NV
jane 26 89898 NV

assuming that the name john is in A2 and Jane is in A3.

on sheet two I have a form where I can select the name from list in the "A" columb. How do I construct a formula to reconize the name and put their state in the "B1" field?

a b
john Automatically pull state when name is selected?


Dont mean to be so breaky with the information but I am new at excel.