General Help

Visitor

Hello,

 

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.

 

Any insight and help will be greatly appreciated.

 

very respectful,

~ar

1 Reply

@NECO-buyer 

Take a look at the FILTER function