Search for specific values in a column, and return values of another range of cells

Hi All,

I've been scouring the internet trying to find the correct formula for what I'm trying to accomplish. I feel like I'm really close on using an INDEX MATCH, but I'm not sure of the keystrokes to achieve what I need.

I am trying to build a sheet that will compile a list of Fixture Numbers into a sheet, based on a value I've entered for them in another column. I've attached an excel file of what I'm attempting to accomplish.

If a value 1.1 is entered anywhere in Column C, then return the adjacent values of the Fixture Numbers in Column A, into Columns F and G. Example, for circuit 1.1, then Fixture Numbers 101 and 102 need to be returned in Columns F and G.

Example, for circuit 1.2, then Fixture Number 201 needs to be returned in Column F


If anyone out there an help me solve this, its been driving me crazy for days. Thank you so much.....Please let me know if I can explain this any differently to make it more clear.

any idea if there would be a way to return up to 6 instances?

Originally Posted by JBeaucaire

Always adjacent in the raw data?

Yes, there could be up to 6 instances under the "fixture number" column that could correspond with a circuit number in that column.

This is why I've been having so much trouble with this, I can't wrap my head around the multiple instances