Lookup info in one Column and then returning info in other columns
 

I have a worksheet full of transaction information about expenses. It's set
up to have date, description, amount, etc. as well as the name of the person
who was responsible for making the transaction. This worksheet will
basically become a data base of transactions made by various individuals. I
want to be able to create a statement of funding available by the person
responsible. The statement of available funding would be on a separate
worksheet. It will list all the transactions just that person made by
pulling them from the data sheet.

When you enter the person's name who is responsible, it will list all the
transactions from the other worksheet every time it encounters that person's
name in the column from the data worksheet. I've seen it work years ago but
can't figure out what formula to use.

If you've done this, please let me know how. Thanks for your help. Cyndi

Lookup info in one Column and then returning info in other columns
 

As responsed in your other posting (you gave more detail there):
-----------------------------------------
Here's an easy, fast non-array play which drives exactly the results that you
seek

Illustrated in this sample:
http://www.freefilehosting.net/download/3ijm5
Filter over lines by key col in another sht.xls

In Sheet1,
Source data is assumed in cols A to F, data from row2 down,
with key col = col F (name)

Put in say, H2:
=IF(Sheet2!$A$1="","",IF(Sheet2!$A$1=F2,ROW(),""))
Copy H2 down to cover the max expected extent of data in key col F
Leave H1 blank

Then in Sheet2,
A dv is created in A1 to select the name, eg: Smith, Jones, etc
In B2: =IF(C2="","",ROWS($1:1))
In C2:
=IF(ROWS($1:1)COUNT(Sheet1!$H:$H),"",INDEX(Sheet1 !A:A,SMALL(Sheet1!$H:$H,ROWS($1:1))))
Copy C2 across to H2. Select B2:H2, fill down by the same extent as in
Sheet1's col H. This returns all the lines for the name selected in A1,
neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cyndi513" wrote:
I have a worksheet full of transaction information about expenses. It's set
up to have date, description, amount, etc. as well as the name of the person
who was responsible for making the transaction. This worksheet will
basically become a data base of transactions made by various individuals. I
want to be able to create a statement of funding available by the person
responsible. The statement of available funding would be on a separate
worksheet. It will list all the transactions just that person made by
pulling them from the data sheet.

When you enter the person's name who is responsible, it will list all the
transactions from the other worksheet every time it encounters that person's
name in the column from the data worksheet. I've seen it work years ago but
can't figure out what formula to use.

If you've done this, please let me know how. Thanks for your help. Cyndi