VLOOKUP


T

Ty

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
 
Ad

Advertisements

T

Ty

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

Nevermind. I followed my steps again. I was making a mistake of
selecting the cells on the 2nd sheet instead of just selecting the
Columns that I wanted to use.

Thanks...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top