Forum Discussion
xaura
Aug 15, 2020Copper Contributor
Pull data from cell in same row as a matched search term
Hey everyone! I have some data I'm trying to track and I'd love to find a formula or mix of formulas that will do exactly what I need so let me explain better then the basics of the title I h...
Riny_van_Eekelen
Aug 15, 2020Platinum Contributor
xaura Consider using a Pivot Table. Rather than collecting sales data in three different sheets, put them all in one, but add a column for product type (H&B, IP, OE).
More about Pivot Tables here:
Attached a simplified example of what it could look like. It gives two different views, based on the same data.