If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup and multiple columns
Hello,
I've looked thru the discussion groups about my question...and I think I have half of it answered (from a posting on 4/15/2004). I understand that to fill multiple columns based on a lookup for one cell...you use =VLOOKUP(A1,A10:F100,{2,3,4,5,6},0) and it will input the info into those 5 columns in the same order as your original table. Now, can you expand this formula to other rows without having to go thru each row and hitting "ctrl shift enter" each time? (I have 5000 rows) I've tried dragging it down, that doesn't work. And I've tried highlighting the entire worksheet and hitting "CSE" and that doesn't work either. Any suggestions? Is there a better way to do this? Thanks for your help. |
#2
|
|||
|
|||
vlookup and multiple columns
Sorry, I meant to say I had a question in my head...and I was able to find half the answer thru other postings, ie, that formula with some variation (=VLOOKUP(A1,A10:F100,{2,3,4,5,6},0) ) but it works for the first row of data, but I can't drag it down to work for all the rows...I even tried the $ suggestion and it didn't work. Is there a better way to do this?
Basically, I have data in 2 separate sheets, and I need to transfer the date from one, to the other: Sheet 1 (the one with the data) Subject ID LName FName Phone 1 Smith Bob 555-5555 2 Jones Joe 444-4444 3 Mark Marky 333-3333 Sheet 2 (the one that needs the data filled in) Subject ID LName FName Phone 1 1 2 3 2 1 1 3 So...for wherever there's a 1...it'll put the info from Sheet 1 there, same with 2, 3, etc. Now I have 5000 Subject Id's...and about 200 columns (which is why I don't want to do a separate VLookup for each column). Any ideas? Thanks so much! |
Thread Tools | |
Display Modes | |
|
|