Grouping & Sub-grouping

[Sunil Pinto]

Dear All,

I have the amounts listed in Column A and the sub-groups in Column B. I need to determine the main group for each entry in Column C, based on the grouping method outlined on the left-hand side.(Find the details attached)

Could anyone assist me in developing a formula for Column C to automatically generate the main group details?

I hope my requirement is clear. Thank you in advance for your support!

Best regards,

Sunil PInto

 

[saboh12617]

Hello,

If you make a 2-columns table from values in column E, with on the 1st column the sub-groups, and on the 2nd column the corresponding main group (the ones in bold), you can use a simple VLOOKUP on this table to get main group from sub-group taken in column B of your table.
Something like

=VLOOKUP(B2, table, 2, FALSE)

 

[Sunil Pinto]

Dear Saboh,

Thank you for your support, problem is solved

 

[saboh12617]

Glad to help, have a good day