Find Value Formula

[kayzdo114]

I want to find value from another sheet that fits 3 conditions: sheet name equal column name that I want to find: Jan, Feb,..; Column I want to find value equal store code: 4201, 4204,... and row number 207

STORE CODE	STORE NAME	Jan	Feb
4201	New World Sai Gon Hotel
4204	Dong Du store

Thank for your help!


Regards

 

[PeteWright]

Since I don't know how your sheets look like and where the cells are, I assume the following:

If this is your "main" sheet:

Book0004.xlsm
	A	B	C	D	E
1	STORE CODE	STORE NAME	Jan	Feb	…
2	4201	New World Sai Gon Hotel	1234	1937	…
3	4204	Dong Du store	4567	4827	…
4	…	…	…	…	…
Main

Cell Formulas
Range	Formula
C2:D3	C2	= INDIRECT(C$1&"!R207C"&XMATCH($A2,INDIRECT(C$1&"!A1:D1"),0,1),FALSE)

And those are your monthly sheets:
Jan

Book0004.xlsm
	A	B	C	D	E
1	4201	4202	4203	4204	…
202	1943	2345	3267	4182	…
203	1783	2943	3671	4369	…
204	1279	2647	3495	4271	…
205	1473	2914	3674	4893	…
206	1497	2347	3981	4925	…
207	1234	2345	3456	4567	…
208	1387	2473	3149	4821	…
209	1247	2498	3197	4734	…
210	1835	2436	3671	4193	…
211	…	…	…	…	…
Jan

Feb

Book0004.xlsm
	A	B	C	D	E
1	4201	4202	4203	4204	…
200	1937	2971	3219	4567	…
201	1497	2134	3937	4129	…
202	1289	2931	3216	4321	…
203	1732	2194	3274	4921	…
204	1927	2734	3694	4932	…
205	1357	2468	3579	4680	…
206	1342	2914	3147	4532	…
207	1937	2314	3962	4827	…
208	1736	2984	3621	4319	…
209	…	…	…	…	…
Feb

You can go with the following formula and adjust it to match your data:
Sheet ="Jan", Store Code = 4201 and ROW = 207 => =INDIRECT(C1"!R207C"&XMATCH(A2,INDIRECT(C1"!A1:D1"),0,1),FALSE)

Change A2 to match your 1. condition (Store Code)
Change C1 to match your 2. condition (Sheet name)
Change A1:D1 to match the cells where your Store Code Header(s) is(are) located