Pulling data

G

Greg KY

I have a xsl file with two sheets One is named data and other is named info
lets say.
On the data sheet lets say there is cell a1:z50000
I need to pull every cell in a row that c3:C5000 matches up with A1 on the
info sheet.

I just want to type in lets say mike in A1 on the info sheet. in cell a2 to
what ever it will pull all cells from the data sheet that that matches A1 on
the info sheet to data on c3:c5000 on the data sheet. I need some help on
this one. Thanks
 
M

Max

Source data in cols A to Z of sheet: data,
data from row3 down, key col = col C

In the other sheet: info,
Input value for the key col C will be made in A1

In B1: =IF($A$1="","",IF(data!C3=$A$1,ROW(),""))
Copy B1 down to cover the max expected extent of source data in the key col
C of "data", say down to B5000?

In C1:
=IF(ROWS($1:1)>COUNT($B:$B),"",INDEX(data!A$3:A$5000,SMALL($B:$B,ROWS($1:1))))
Copy C1 across by 26 cols to AB1, then fill down by the smallest range large
enough to cover the max expected return lines per particular input in A1, say
down to AB100? The required results will appear in cols C to AB.
Minimize/hide col B.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top