ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   only returning 1st matching entry in table, need to find next matc (https://www.excelbanter.com/excel-worksheet-functions/173971-only-returning-1st-matching-entry-table-need-find-next-matc.html)

nwtf_vol[_2_]

only returning 1st matching entry in table, need to find next matc
 
I am trying to create a receipt from a list of auction items with the
buyer/cust# in column a, the item# in column b, and the description in column
c. The receipt has the buyer/customer # in cell E7, and I would like the
purchases to start in row 17 and go down from there (B17 is the item#, C17 is
the item description, and E17 is the item price). As the items are sold, I
will be filling in the buyer/cust# next to the auction item in the worksheet.
When the auction is over, I would like to be able to key in the buyer number
on the receipt worksheet and have the purchases fill in so I can print a
receipt. I have the receipt formatted and created and it will work for one
purchase only. However, I am having trouble when a user has multiple
purchases because when I lookup the data, I always only find the first entry
for a specific customer in the list. Can someone help me with a formula to
return those other matching values? Thank you!


All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com