Find Cell from Parent Column

[PioneerBear]

I have a workbook that uses a "Main" page for overview of information. Several of the areas of information are un-aligned when I may no longer have visibility of perspective dates of requested information - causing some groups to either enlarge or shrink.

What formula or how, would I be able to I guess Find the information based off a "Mother" column? I apologize if my most apt wording of the question is not the best description.

For chart below, I need D21, E21 &, F21.

Issue, this chart changes daily. So tomorrow, I may not have the dated row C14-17 causing previously requested cells to be on lower numbered rows.

 

[Kaper]

So you need Instagram total values?

Use in some empty cell (let's say J2 - or any other located right from the table) the following formula:

=vlookup("Instagram",$A:$F,columns($A$1:D$1),0)

and copy the cell with the formula to 2 next cells to the right

 

[Kaper]

PS. if you write in I2 Facebook, in I3 Instagram, and so on down, then formula in J2 (and copied down and right) shall be:

=vlookup($I2,$A:$F,columns($A$1:D$1),0)

or, as you have a recent Excel version delete anything in J2 and right/down and in J2 write a short spill formula:

=FILTER(D:F,COUNTIF(I2:I3,A:A))

adjust only I2:I3 to the length of your list in column I

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	facebook	total		123	321	11			facebook	123	321	11
3									instagram	222	333	4
4									likedin	55	555	5555
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20	instagram	total		222	333	4
21
22
23
24	likedin	total		55	555	5555
25
Sheet1

Cell Formulas
Range	Formula
J2:L4	J2	=FILTER(D:F,COUNTIF(I2:I4,A:A))
Dynamic array formulas.