Return value based on different criteria

[Namescody]

Hello everyone,

I know this is probably easy - but for some reason I'm having trouble with getting a formula to work correctly. I am trying to populate a certain value in Column D based on different criteria in Column F.

Column F will contain "ABC Employee Name" or "XYZ Employee Name" or "DEF Employee Name" or "LMN Employee Name"

and I want Column D to auto-populate with a value for each prefix.

I.E. If Column F contains "ABC Employee Name" return 123 in Column D
If Column F contains "XYZ Employee Name" return 456 in Column D

and so on...

 

[Nine Zero]

Re: [Help]Return value based on different criteria

Hello,

Try this out

=IF(LEFT(F1,3)="ABC",123,IF(LEFT(F1,3)="XYZ",456,0))

add an additional if statement for each prefix and each result that you would like to have

 

[Namescody]

Re: [Help]Return value based on different criteria

Thanks! That worked, originally I got an error of too many arguments so I just removed the ",0" at the end of each.

Hello,

Try this out

=IF(LEFT(F1,3)="ABC",123,IF(LEFT(F1,3)="XYZ",456,0))

add an additional if statement for each prefix and each result that you would like to have

 

[Nine Zero]

Re: [Help]Return value based on different criteria

Ahh yeah must have overlooked that!

Glad i could help