Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Searching and Retrieving data from a Worksheet
I am trying to search a worksheet for a unique identifier and the extract all
of the data on that row to another worksheet. I have used and am comfortable with VLOOKUP, but this only pulls one cell. Can this be accomplished without using VB and if so, what is the function I can use? |
#2
|
|||
|
|||
Larry
Method 1.......copy the VLOOKUP formula across and change the column_index number in each one. i.e. 8 column table, change col_index from 2 to 3 to 4 etc. Method 2.......... Select the number of Sheet2 cells across, say 7, B1:H1 Enter this formula in active cell(B1) =VLOOKUP(A1,Sheet1!$A$1:$H$20,{2,3,4,5,6,7,8},FALS E) CTRL + SHIFT + ENTER to enter then drag/copy down if need be. Gord Dibben Excel MVP On Tue, 1 Mar 2005 10:11:02 -0800, Larry Snyder wrote: I am trying to search a worksheet for a unique identifier and the extract all of the data on that row to another worksheet. I have used and am comfortable with VLOOKUP, but this only pulls one cell. Can this be accomplished without using VB and if so, what is the function I can use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|