rules for when formula is applied

[brianaclark1967]

Hi Guys,

I have a sheet that is collecting information.

Can I alter the formula so it only works when a certain keywords are in a certain cell.

For example:

This is my formula,

=IFERROR(INDEX(Sales!L:L,MATCH(IN!E4177,Sales!C:C,0)), "")

I only want this formula to apply if cell C4177 contains “Debit Card” or “Credit Card”

Many thanks guys

Regards

Brian

 

[Khalid NGO]

Hi Brain,
Try this:

=IF(OR(C4177="Debit Card",C4177="Credit Card"),IFERROR(INDEX(Sales!L:L,MATCH(IN!E4177,Sales!C:C,0)), ""),"")

Regards,

 

[brianaclark1967]

HI Khalid,

Thank you so much for your prompt reply.

It works really well

Many thanks and regards

Brian

 

[Khalid NGO]

HI Khalid,

Thank you so much for your prompt reply.

It works really well

Many thanks and regards

Brian

You are welcome Brian.