|If you have a relatively large number of conditions to deal with, an IF function can be cumbersome.|
Another option is to use VLOOKUP. With VLOOKUP you can build a table of choices that is essentially unlimited. A table of data might also be easier to change than a IF function, especially if the IF function is long and complicated.
As AlteK mentioned, there are lots of options, but we'd need more details to offer any more suggestions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.