I'm using VLOOKUP. From what I understand, VLOOKUP looks at the first
column and matches up the values with the first column on the 2nd
sheet. Now, my problem is that I have a column of 30 names. I do my
formula on B2 "=VLOOKUP(A2,Sheet1!A1:B30,2,FALSE)". Now, I would like
to have the exact same formula on each cell following B2. B3 should =
(equal) B2. Right now, when I:

copy
place cursor in B3
ctrl-sh-end(goes to the end of the data not the whole ss)
sh <--- arrow over to narrow it down to just that column
hit enter

My end result is a formula that changes the A1:
=VLOOKUP(A2,Sheet1!A1:B30,2,FALSE)

Examples:
A1 & A2 on Sheet 1
last 4 of social 8999 /A1 Ty Bak/A2

A1 & A2 on Sheet 2
4 ssn 8999/A1 Win32/A2
4 ssn 2244/A2 UNIX/A2
4 ssn 3322/A3 OS390/A2

Thanks,
Ty