Project: I'm using Excel to create a receipt/invoice for buyers at a local high school auction. I have three pages in my excel workbook. First page: Buyer information (this will include their bid number), second page: products, third page: receipt/invoice. I'm using VLookup to grab the descriptions and price of each product to populate my invoice body. Is there a formula/function that can also populate the product number based on the buyer number that appears at the top of the invoice? I'd be ever so grateful... everything i've tried returns an error.
Because this is an auction, it's possible that the same buyer (bid number) could buy multiple items. Each product (only 1 qty) has a unique item number assigned. So, my product sheet is filled with 100s of items with their descriptions and prices. We won't know how many buyers we have until the evening of the auction, but when testing the receipt it's already a pain to scroll through the hundreds of product numbers when using the list option in data validation. We have student and elderly volunteers, so we need this to be simplified.
If that's wishful thinking, can you tell me how to limit the number of products that appear in the drop-down menu based on the bidder number so we're not combing through 100s of products to find the 3 or 4 items the buyer has won?
Your wisdom is greatly appreciated!! I'd attach screen shots, but being a new member I can't attach files. Hopefully you can visualize what I'm describing
Because this is an auction, it's possible that the same buyer (bid number) could buy multiple items. Each product (only 1 qty) has a unique item number assigned. So, my product sheet is filled with 100s of items with their descriptions and prices. We won't know how many buyers we have until the evening of the auction, but when testing the receipt it's already a pain to scroll through the hundreds of product numbers when using the list option in data validation. We have student and elderly volunteers, so we need this to be simplified.
If that's wishful thinking, can you tell me how to limit the number of products that appear in the drop-down menu based on the bidder number so we're not combing through 100s of products to find the 3 or 4 items the buyer has won?
Your wisdom is greatly appreciated!! I'd attach screen shots, but being a new member I can't attach files. Hopefully you can visualize what I'm describing
