Searching and Retrieving data from a Worksheet

[Larry Snyder]

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?

 

[Gord Dibben]

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},FALSE)

CTRL + SHIFT + ENTER to enter then drag/copy down if need be.


Gord Dibben Excel MVP