How to VLOOKUP data with multiple criteria to match and extract the correct column data

[jaden888]

Hi,



I am having 3 workbooks, called A, B and Master.



Basically, A and B workbooks have the same format table with some data based on different stores. Every week new columns will be created with a new date in workbooks A and B.



I want to again look for and extract data based on the store name and also the correct date column with the following data together in my Master workbook.



In my Master workbooks, I would like to learn how to VLOOKUP in sheets VLOOKUP-A and VLOOKUP-B to extract data from workbooks A and B.

Links to my workbooks

Or if there is better way/solutions feel free to share with me.

Thank you

 

[cyrilbrd]

Hi there, please use this tool to post a sample.

 

[jaden888]

Hi there, please use this tool to post a sample.

Thank you for sharing how to use the XL2BB.

Workbook "A":

A.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	10			38%			35%			72%
2	STORE	Volume Stock	VIP URGENT	07-Mar	PC	NGPM	28-Mar	PC	NGPM	04-Apr	PC	NGPM
3	A	1	1	12%	62%	67%	31%	37%	79%	76%	51%	56%
4	B	0	0	62%	14%	84%	2%	90%	68%	79%	39%	50%
5	C	0	0	90%	54%	48%	3%	23%	49%	40%	3%	16%
6	D	1	0	31%	55%	43%	76%	11%	32%	73%	81%	37%
7	E	1	1	14%	54%	99%	37%	77%	86%	59%	26%	92%
8	F	0	1	52%	38%	60%	69%	38%	60%	84%	15%	96%
9	G	1	1	0%	28%	63%	49%	1%	40%	57%	17%	0%
10	H	1	1	49%	67%	58%	55%	55%	92%	90%	7%	96%
11	I	1	0	5%	78%	68%	6%	47%	71%	90%	53%	24%
12	J	0	0	67%	42%	17%	20%	85%	86%	68%	81%	91%
ANALYSIS

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(A3:A100,"*")
D1,J1,G1	D1	=AVERAGE(D3:D12)
B3:L12	B3	=RAND()

Workbook "B":

B.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	10			31%			60%			46%
2	STORE	Volume Stock	VIP URGENT	07-Mar	PC	NGPM	28-Mar	PC	NGPM	04-Apr	PC	NGPM
3	K	0	0	8%	74%	62%	94%	72%	23%	1%	98%	81%
4	L	1	0	3%	90%	44%	74%	64%	55%	22%	21%	21%
5	M	0	0	89%	35%	11%	95%	82%	34%	16%	30%	28%
6	N	0	1	20%	13%	77%	51%	73%	65%	92%	9%	14%
7	O	0	1	67%	0%	31%	51%	31%	3%	69%	60%	6%
8	P	1	0	64%	11%	50%	11%	24%	7%	94%	53%	58%
9	Q	0	0	27%	85%	72%	45%	47%	65%	83%	44%	34%
10	R	0	0	5%	16%	35%	17%	24%	93%	17%	9%	86%
11	S	0	1	1%	14%	6%	88%	79%	62%	27%	18%	21%
12	T	1	0	22%	81%	52%	71%	24%	26%	38%	42%	70%
ANALYSIS

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(A3:A100,"*")
D1,J1,G1	D1	=AVERAGE(D3:D12)
B3:L12	B3	=RAND()

Workbook "Master"

MASTER.xlsx
	A	B	C	D	E	F	G	H	I	J
1	10
2	STORE	07-Mar	PC	NGPM	28-Mar	PC	NGPM	04-Apr	PC	NGPM
3	A
4	B
5	C
6	D
7	E
8	F
9	G
10	H
11	I
12	J
VLOOKUP-A

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(A3:A100,"*")

MASTER.xlsx
	A	B	C	D	E	F	G	H	I	J
1	10
2	STORE	07-Mar	PC	NGPM	28-Mar	PC	NGPM	04-Apr	PC	NGPM
3	K
4	L
5	M
6	N
7	O
8	P
9	Q
10	R
11	S
12	T
VLOOKUP-B

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(A3:A100,"*")