If then statement, multiple conditions, multiple actions using OR

I am having trouble using a fairly simple If then statement using OR. I have attached a sample file. I am simply trying to create a field with the new product group name, based on the old name. Column C is the old product group. Column D is where I want the new product group name to appear. In one statement, I want the formula to spell out:

if C2 is Tools_Service then D2 is TLS OR

if C2 is Software_Service then D2 is SAAS OR

if C2 is Managed_Service then D2 is MSP OR

if C2 is Cloud_Computing then D2 is CLD OR

if C2 is Consulting_Service then D2 is CSLT OR

if C2 is Angel_Funding then D2 is AFD

It would be easier to build up a little table with those values, and then you can use the VLOOKUP function. Put these values in G1:G6:

Tools_Service
Software_Service
Managed_Service
Cloud_Computing
Consulting_Service
Angel_Funding

and then the corresponding values in H1:H6:

TLS
SAAS
MSP
CLD
CSLT
AFD

and then you can use this formula in D2:

=IFERROR(VLOOKUP(C2,$G$1:$H$6,2,0),"")

and copy this down as far as you need to.

Hope this helps.

Pete

worked perfectly thank you! Just curious...if I had used an IF Then OR statement, would it have been too many arguments?

No, you could have done it with this formula (put it in E2 to check):

=IF(C2="Tools_Service","TLS",IF(C2="Software_Service","SAAS",IF(C2="Managed_Service","MSP",IF(C2="Cloud_Computing","CLD",IF(C2="Consulting_Service","CSLT",IF(C2="Angel_Funding","AFD",""))))))

and you can see that you don't need to have any OR functions as they are implied as you move from one IF to the next.

It's just easier to maintain a simple table and one function, rather than that large formula.

Hope this helps.

Pete

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Probably not as the IF function accommodates 7 nesting levels

Ok! So it really wasn't an OR condition after all. Thank you so much