IF ERROR INDEX MATCH - need assistance in how to get rid of N/A to produce two other options

[jwoo89]

Hi,

I am trying to figure out how to get the formula to below return something if it errors out.

Right now i have the number 15 being produced if there is an error.

but i am trying to figure out if i can have two formulas in the iferror.

i.e. If D2="eqty" to produce 15 or if D2="opt" to produce 25 when it says N/A if not found on the table.


=IFERROR(INDEX('fee'!D:D,MATCH(1,(Sheet3!C2='fee'!B:B)*(Sheet3!D2='fee'!C:C),0)),15)

 

[Fluff]

How about

=IFERROR(INDEX(fee!D:D,MATCH(1,(Sheet3!C2=fee!B:B)*(Sheet3!D2=fee!C:C),0)),IF(D2="eqty",15,20))

 

[jwoo89]

thank you so much! what if it was three options, say if D2=opt should be 25, D2=eqty = 15, D2 = wire, 30?

 

[Fluff]

Try

=IFERROR(INDEX(fee!D:D,MATCH(1,(Sheet3!C2=fee!B:B)*(Sheet3!D2=fee!C:C),0)),IF(D2="eqty",15,if(d2="opt",25,30)))

 

[jwoo89]

you are awesome!!! thank you so so much

 

[Fluff]

You're welcome & thanks for the feedback.