IF Vlookup query

[Marianka]

Good day,

I have 2 sheets within a workbook.

One sheet will compare items and prices across various branches and he other sheet contains a list of items from the branches.
On the comparison sheet, I want to run a calculation that first checks the branch and then the item code and related values which must then be returned to the cells on the comparison sheet.

 

[jorismoerings]

Hi and welcome to MrExcel,

try this and see if this is fit for purpose:

Book1
	A	B	C	D	E	F	G	H
1			H&M Vereen			H&M Cape
2	Code	Unit	QTY	Price	Price per unit	QTY	Price	Price per unit
3	Aerothene	Metre	3	3	3	2	2	2
comparison

Cell Formulas
Range	Formula
C3:H3	C3	=INDEX(CAPE!$D$2:$F$15,MATCH(1,(OFFSET(C$1,0,-MATCH(C$2,CAPE!$D$1:$F$1,0)+1)=CAPE!$A$2:$A$15)*(comparison!$A3=CAPE!$B$2:$B$15),0),MATCH(C$2,CAPE!$D$1:$F$1,0))

 

[Marianka]

I tried this, but the result is #N/A

 

[jorismoerings]

Can you show your attempt using XL2BB.
That’s an add in which copies data, range and formula. See forum FAQ for the link.