VLOOKUP
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 |
VLOOKUP
On Aug 6, 8:52*am, Ty wrote:
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... |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com