combine results

[joeloveszoe]

hi
i have 2 XMATCH - INDEXes .... finding results from 2 spreadsheets with costs
i'd like to find an easy way to combine results in one column (and keep column color)
with this example - with Z & AA being the 'master"
move all results into AC
(results (INDEX) in Y & AA)
move results from AA to AC
but - if the is an N/A in Z but a value in X take Y and put into AC

make sense?
thanks =)

 

[awoohaw]

Mr. Excel has an add in called xl2bb (link below), can you please use that to post a mini sheet of your DATA. If you cannot then please post your data as a table.

Asking the forum to recreate your scenario is time consuming and they may have typos that cause further problems.

Also please post some expected results.

You need not give all data, just enough so the forum understands your data structure and objective.

 

[joeloveszoe]

Sanford rePrice 7-1-23.xlsx
	X	Y	Z	AA	AB	AC
1	ISG line	JUL 2023 Direct Cost	Newell line	Newell cost	Min Order Qty	COST
136	35705	11.95	1359	11.95	5	11.95
137	35706	11.95	1360	11.95	5	11.95
138	#N/A	#N/A	1362	11.95	6	11.95
139	35707	16.16	1363	16.16	5	16.16
140	35708	1.69	1347	1.69	10	1.69
141	35709	1.69	1348	1.69	10	1.69
142	35710	1.69	1349	1.69	10	1.69
143	#N/A	#N/A	1364	15.75	5	15.75
144	35711	10.53	1397	10.53	1	10.53
145	35712	13.18	1329	13.18	5	13.18
146	35715	4.56	1372	4.56	6	4.56
147	35716	4.56	1373	4.56	6	4.56
148	#N/A	#N/A	1371	4.34	6	4.34
149	35717	4.56	1374	4.56	6	4.56
150	35718	24.97	#N/A	#N/A	#N/A	24.97
151	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
152	35719	9.88	#N/A	#N/A	#N/A	9.88
153	35720	0.62	#N/A	#N/A	#N/A	0.62
154	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
155	35721	145.98	#N/A	#N/A	#N/A	145.98
156	35722	59.08	#N/A	#N/A	#N/A	59.08
157	35723	34.55	#N/A	#N/A	#N/A	34.55
158	35724	3.41	#N/A	#N/A	#N/A	3.41
159	35725	41.7	#N/A	#N/A	#N/A	41.7
160	35726	40.28	#N/A	#N/A	#N/A	40.28
161	35727	26.81	#N/A	#N/A	#N/A	26.81
162	35728	19.07	#N/A	#N/A	#N/A	19.07
163	35729	15.3	#N/A	#N/A	#N/A	15.3
164	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
165	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
166	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
167	35730	7.27	#N/A	#N/A	#N/A	7.27
168	#N/A	#N/A	1553	21.66	2	21.66
169	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
170	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
171	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
172	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
173	35739	11.06	#N/A	#N/A	#N/A	11.06
174	35740	11.48	#N/A	#N/A	#N/A	11.48
175	35742	9.23	1494	9.23	12	9.23
vendor-Sanford

Cell Formulas
Range	Formula
X136:X175	X136	=XMATCH(C136,'ISG price FIle'!C:C)
Y136:Y175	Y136	=INDEX('ISG price FIle'!P:P,X136,1)
Z136:Z175	Z136	=XMATCH(B136,'Newell PriceFile'!H:H)
AA136:AA175	AA136	=INDEX('Newell PriceFile'!S:S,Z136,1)
AB136:AB175	AB136	=INDEX('Newell PriceFile'!Q:Q,Z136,1)
AC136:AC149,AC151,AC154,AC164:AC166,AC168:AC172,AC175	AC136	=AA136
AC150,AC152:AC153,AC155:AC163,AC167,AC173:AC174	AC150	=Y150

Mr. Excel has an add in called xl2bb (link below), can you please use that to post a mini sheet of your DATA. If you cannot then please post your data as a table.

Asking the forum to recreate your scenario is time consuming and they may have typos that cause further problems.

Also please post some expected results.

You need not give all data, just enough so the forum understands your data structure and objective.

ok! trying =)
thanks!

 

[joeloveszoe]

is that helpful?

 

[awoohaw]

is that helpful?

yes, but you need to also post some miniworksheets from the other two worksheets. And they should have data the formulas should find.