jeudi 30 juin 2016

Excel Macro Best Practice for Multiple options in If Statement or Case

I have multiple "Call Types" (from "Roaming" to "International") and I need a vlookup to apply the correct rate depending on the type in an excel macro.

What's the best practice to do this?

If CategoryType = "Roaming" AND Country coainted in List A Then

If List B Then

Do I use arrays? How do you check if a string is in an array in an IF statement?


Rates Table Example

Aucun commentaire:

Enregistrer un commentaire