Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |