Forum Discussion
SLA project
Hello there, We're starting a project & have multiple SLA's from different countries. There are some groups that require more than just 2 letters as abreviations (Austria - AT; Group #1 - HG; etc...
Anonymous ,
You may take a look at the post below.
Thank you for the reply.
Unfortunately, this doesn't solve our issue. We've done it & we don't need just a replication of a vlookup formula, but a combination of 2 vlookup formulas so that when it gets the case with the same 2 first letters then it looks in another location in order to know which of the 2 groups it's from.
Case A (CG#1 - Country Group #1)
Case B (CG#2 - Country Group #2)
We need the formula to also look in another column with the Company Code to know which CG is from.