INDEX and IF statement?

[Tatum2020]

Hello,

I hope you're all well and keeping safe.

I hope you can assist me with what could be an easy fix.

I have two sheets, the first sheet is a summary sheet and the second is a raw data/ data dump sheet (please see example below):

Sheet 1: Summary

KPIs	Week 19	Week 20
Revenue	100	200
Profit	20	120

Sheet 2: Raw data

KPIs	Week 19	Week 20	Week 21	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25
Revenue	100	200	180	220	200	180	150	220	200
Profit	20	20	30	50	30	25	30	50	50

What I would like to do (if possible), is that the revenue and profit figures automatically populate in sheet 1 when I change the week numbers? E.g., if I delete week 19 and type Week 22. The figures from Week 22 from the raw data tab should automatically populate. I hope I am making sense.

Please help!

Thank you in advance.

 

[AlanY]

try

Book1
	A	B	C	D	E	F	G	H	I	J
1	KPIs	Week 19	Week 23
2	Revenue	100	150
3	Profit	20	30
4
5	KPIs	Week 19	Week 20	Week 21	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25
6	Revenue	100	200	180	220	200	180	150	220	200
7	Profit	20	20	30	50	30	25	30	50	50
Sheet3

Cell Formulas
Range	Formula
B2:C3	B2	=INDEX($B$6:$J$7,MATCH($A2,$A$6:$A$7,0),MATCH(B$1,$B$5:$J$5,0))