Assign group name to a list of values within another column

[Jacks18928jl]

Hello

Thanks in advance for any help

I have a list of values, which I need to group under different group names, using a formula

Please find attached output examples

Cheers

[AliGW]

Whilst I have a look, please go back to your previous thread, where there are posts and assistance you have not acknowledged: https://www.excelforum.com/excel-for...fic-value.html

Thanks.

[AliGW]

OK - a few questions.

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	E	F	G	H
1	Group Name	Actual Status	Ticket	Ticket Detail
2	Planned	Triage	1	dhdhjk
3	In Progress	In Progress	3	fdsjkfdj
4	Planned	Scope Review	6	dfjksldjflk
5	Testing	Post-Deployment QA	5	dfjksldjflk
6	Dev Hours	Dev Hours Supplied	7.5	dfjksldjflk
7	Backlog	Backlog	9	dfjksldjflk
8	Cancelled	Cancelled	10.5	dfjksldjflk
9	Planned	Planned	12	dfjksldjflk

Sheet: Sheet1

1. How do I know which of the group names you want in the output?
2. Where has the data in Ticket and Ticket Detail come from?

There are clearly significant details missing from your request in the opening post. More detail, please, as I am not clairvoyant.

[Jacks18928jl]

Thanks for taking a look

I need a mapping formula to add to column E

- map values in column A to column C names
- column E add above mapping formula, which reads column F

Please ignore the ticket and detail values.

Thanks

[AliGW]

I'll have another look. Did you see post #2? In your last thread I made changes you requested but you never acknowledged them or marked the thread as solved - plesae go and look now.

[AliGW]

Remove ALL expected results from E. Paste this into E2 and ENTER:

=XLOOKUP(F2:F9,A2:A18,C2:C18,"")

It will spill down.

There is a gap owing to a spelling mismatch in your lists - you can find and correct this yourself.

[Jacks18928jl]

Thanks for that

Column C - I have to type in planned, when status value is triage or planned in column A

Is there a formula that can auto do that please?

Example

- Triage or planned, return the term planned
- Todo, in review or in progress, return the term in progress

Thanks

[AliGW]

No - that's your lookup list. The source data (lookup list) has to start somewhere.

[Jacks18928jl]

No probs, thanks for your help

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.