Display a code based on if there is value in a field

[new2xcel]

Hi all,

I am working on a delivery log spreadsheet which tracks deliveries and types of delays. There are multiple types of delay, for example unloading, paperwork, etc, and these are displayed in time. If there is any value in one of these fields I need the "code" column to display the corresponding code. For example, if there is a 10 min unloading delay, I need the code column beside that corresponding delivery to display "U" or if there is a 45 minute paperwork delay, I need the code "P". The time is irrelevant and typically there aren't more than 1 type of delay in the same delivery.

Sorry if this has been asked before, I am not sure what this is called. I have done some searching but couldn't find anything related.

Thanks for any help!

EDIT: the example workbook just has the basic fields, and I populated the code column based on how I would like it to look. but I am looking for a solution/formula to automatically populate the code field.

[AliGW]

Welcome to the forum.

2103 is merely a release number for MS365, which is the version you need in your profile, please.

There are instructions at the top of the page explaining how to attach your sample workbook.

[new2xcel]

Apologies, updated and added an example attachment to OP.

[Fluff13]

Hi & welcome to the board.
How about

Please Login or Register  to view this content.

[AliGW]

In F3 copied down:

=LEFT(INDEX($C$2:$E$2,MATCH(1,$C3:$E3,1)),1)

[wk9128]

Cell F3 formula , Drag down

[new2xcel]

works great, thank you so much!

[Fluff13]

Glad to help & thanks for the feedback.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon 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 those who helped.