I am needing some general direction in a workbook. If it turns out in going in deeper I can provide some examples. However, I (at least like to) think, that once a get a starting point, I will be able to figure out the rest on my own.
I have a workbook with 3 sheets of very similar setups with organizing different products in rows with data from vendors in columns. I have a column that identifies the favorable vendor. Each sheet is a different class of product and the layout is copied.
What I want is a way on another sheet choose the vendor and by using formulas have those rows populate. The problem I run into with XLOOKUP and XMATCH is finding the multiples. The first row is great, but the next is a flop.