Vlookup/index match or something else?

[Pizzio]

I'm looking for a formula that will break out all values associated with a specific reference. Below shows a single reference ID but I believe I'll be using 2 for this project. Any help is GREATLY appreciated.

******** language="JavaScript" ************************************************************************>

Book3
	A	B	C	D
1	DataSet
2	Ref	Values
3	1	Blue
4	5	Green
5	1	Blue
6	1	Pike
7	6	Red
8	4	Orange
9
10	ReturnValues
11	Ref	Value1	Value2	Value3
12	1	Blue	Pike
13	4	Orange
14	5	Green
15	6	Red
Sheet3

 

[James006]

Hi,

You can Insert a Pivot Table ....

Hope this will help

 

[Pizzio]

The data is across several sheets that I'm trying to bring in the data. That's why I'm looking for a formula.

 

[James006]

Hello,

In order to create a Pivot Table from multiple sheets ...

https://www.contextures.com/xlPivot08.html

Hope this will help