Forum Discussion

BooBar87's avatar
BooBar87
Copper Contributor
Feb 05, 2024

Nested IFERROR Help

I’m trying to lookup prices from a sheet using index and match.   I ran into problems with my initial index and match, so started by doing 3 different index and matches for the different product ty...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 05, 2024

BooBar87 

=IFERROR(

IFERROR(

IF(F2="Set of 5",INDEX(Supplier!$C$5:$I$13,MATCH($D2,Supplier!$A$5:$A$13,0),MATCH($C2,Supplier!$C$4:$I$4,0),MATCH($M2,Supplier!$C$3,0))*5,INDEX(Supplier!$C$5:$I$13,MATCH($D2,Supplier!$A$5:$A$13,0),MATCH($C2,Supplier!$C$4:$I$4,0),MATCH($M2,Supplier!$C$3,0))),

IF(F380="Set of 5",INDEX(Supplier!$K$5:$M$13,MATCH($D380,Supplier!$A$5:$A$13,0),MATCH($C380,Supplier!$K$4:$M$4,0),MATCH($M380,Supplier!$K$3,0))*5,INDEX(Supplier!$K$5:$M$13,MATCH($D380,Supplier!$A$5:$A$13,0),MATCH($C380,Supplier!$K$4:$M$4,0),MATCH($M380,Supplier!$K$3,0)))),

IF(F542="Set of 5",INDEX(Supplier!$N$5:$P$13,MATCH($D542,Supplier!$A$5:$A$13,0),MATCH($C542,Supplier!$N$4:$P$4,0),MATCH($M542,Supplier!$N$3,0))*5,INDEX(Supplier!$N$5:$P$13,MATCH($D542,Supplier!$A$5:$A$13,0),MATCH($C542,Supplier!$N$4:$P$4,0),MATCH($M542,Supplier!$N$3,0))

)

)

Resources