EASY EASY EASY.... You just need to use the =vlookup() function with an if
function.
I mean:

in a cell: If([Vendor column:column number]="abc printing",vlookup([Range
starting from the first cell of vendor column until last cell of
Amount],{1,2,3}),"")

ex.

cell b2 you will put: =if(sheet1!b2="abc
printing",vlookup(sheet1!$b$2:$d$7,1,)"")
cell c2 you will put: =if(sheet1!b2="abc
printing",vlookup(sheet1!$b$2:$d$7,2,)"")
cell d2 you will put: =if(sheet1!b2="abc
printing",vlookup(sheet1!$b$2:$d$7,3,)"")

and you copy the cells b2 c2 and d2 7 times to the bottom of the page¡¡¡

"taxmom" wrote:

Hi,

I have been unsuccessful in trying to figure out a formula that will look at
data in one spreadsheet and post all of the items found into another
worksheet.

example: worksheet 1 contains daily transactions in separate columns:
date vendor ck# amount
1/5/05 abc printing 504 100
1/5/05 sbc telephone 505 100
1/5/05 super coups 506 300
2/7/05 abc printing 507 100
2/8/05 sbc telephone 508 300
2/30/05 abc printing 509 200

I need the abc printing worksheet to be able to pull all of the payment
data; date, ck#, & amount made to them that is listed on the daily
transaction worksheet. Even if it is not in order.

I want to eliminate doing a sort or pivot table everytime we want to look at
how much we have paid someone. I would like it to flow directly on to
another worksheet.

Can this be done?
I would appreciate any help I can get. Thanks