conditional data transfer from multiple sheets

J

James

I have a worksheet for a charity auction I have been working on and need some
help. Sheet 1 is the items it has 7 columns Item#,Description,Donated
By,Current bid, High Bid,Auction Closed,and Winning bid. steets 1-50 are the
bidder invoices. what i need to do is move the item #, description and
winning bid to the invoices that correspond with the bidder #. I tried
=IF(Items!E3=1,Items!B3,"") but if bidder 2 wins that item that row is blank
and the invoice is 500 rows long even if the bidder only got 1 item.

Thanks,
 

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

Help With A Spreadsheet for a silent auction 1
Macro or Lookup? Not sure where to start. 1
Search/Lookup and Place 2
calculating age of debt (30,60,90 days) 1
Find min sum from multiple categories and functions 2
Search records message box 5
new user needs help 8
Advanced Mail merge invoice from excel database 0

Top