multicriteria look up

[aarti_rto]

Hello Experts,

i have below source data for 2 years , each month seperately.

Jan-25	Feb-25
Actual Purchase from External Supplier	As per calculation - internal	Jan-25	Jan-25	Jan-25	Actual Purchase from External Supplier	As per calculation - internal	Feb-25	Feb-25	Feb-25
Part number	price 1	purchase qty	value	price 2	Sale qty	value	total value	Qty	Prc	price 1	purchase qty	value	price 2	Sale qty	value	total value	Qty	Prc
ABC	0	0	0	28.66	1641511	47050374.66	47050374.66	1641511	28.66	0	0	0	0.00	626160	0	0	626160	0.00
XYZ	0	0	0	18.26	502385	9172321.185	9172321.185	502385	18.26	0	0	0	0.00	176399	0	0	176399	0.00
DEF	31.02028037	68400	2121787.178				2121787.178	68400	31.02	0	0	0	0.00	72160	0	0	72160	0.00

and i need "Qty" column wrt month in another file.
below is the format of another file..

Actual

Actual

Actual

Jan-25

Jan-25

Jan-25

Feb-25

Feb-25

Feb-25

Jan-25

Jan-25

Jan-25

Part No

Part Name

Wt

Main Product Group

Prc

Qty

Val

Prc

Qty

Val

Prc

Qty

Val

ABC

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

XYZ

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

here I need the "prc" from source file wrt month and part no

here I need the "qty" from source file wrt month and part no

 

[stigcorneer]

You can use =XLOOKUP() and combine the multiple lookup criterias with &.

Example
=XLOOKUP("ABC",Partnumbercolumn,XLOOKUP("Feb-25"&"Prc",Monthheaderrow&OtherHeaderRow,DataArea))

Not a great example because you have no celladresses in your picture. But I hope you get the idea.