Retrieving a row from another worksheet

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a worksheet named "Master" that contains a
information. This is sorted by one "key" column. I want
to create other worksheets and only enter the "key"
information and have Excel pull all the rest of the
associated information from the row.

Thanks.
 
Take a look at the =vlookup() function in help.


I have a worksheet named "Master" that contains a
information. This is sorted by one "key" column. I want
to create other worksheets and only enter the "key"
information and have Excel pull all the rest of the
associated information from the row.

Thanks.
Click to expand...
 
VLOOKUP will do that for you. In A2 of your "other" worksheet enter the data
you want to look up.

In B2 of that ws, enter =VLOOKUP(A2,Master!DataRange,2,False)
In C2 enter =VLOOKUP(A2,Master!DataRange,3,False)
In D2 enter =VLOOKUP(A2,Master!DataRange,4,False)

Continue that pattern to the right as far as needed. Select the cells from
A2 to the last one on the right and drag down to fill the formulas to the
end of your data.
 
You received two responses directing you to the VLOOKUP function. That
will work for you only if the "key" column is the lefthand column of
your data. Perhaps you could describe more fully the structure of your
data so that someone can decide whether INDEX/MAX functions will work
for you or if you need to use a filter.

Alan Beban
 
Back
Top