Mulitple text options in range of cells equals unique values in different range of cells

If I have one of the following three different text options, "Supplier Escape" "Customer Escape" or "Internal Escape" populated in range J4:J3000 I would like for each option to equate to a specific number value in the corresponding cell in range N4:N3000.

For example: If supplier escape is in cell J9 then the value in H9 should be 5.
If internal escape is in J11 then the value in H11 should be 30

Originally Posted by FDibbins

Hi, welcome to the forum

Maybe something like this?

=if(J9="supplier*",5,if(J9="Customer*",15,if(J9="Internal*",30,0)))

Ford- Thank you for following up with me! Still have a few bugs. Let me know if you have any other suggestions! They're much appreciated.
It doesn't reject the formula; however, when I plug it in to the cell where I'm trying to populate the specific value, all I get is 0

=IF(J7="Supplier Escapes",5,IF(J7="Customer Escapes",10,IF(J7="Internal Escapes",30,0)))

This works fine for me. Don't see why you are having issues? Cell J7 would have to match 100%. I assume it does?

Originally Posted by DannyJ

This works fine for me. Don't see why you are having issues? Cell J7 would have to match 100%. I assume it does?

Gentlemen-
I am an idiot and yes it works, unlike my brain on occasion.

Originally Posted by pvancool

Ford- Thank you for following up with me! Still have a few bugs. Let me know if you have any other suggestions! They're much appreciated.
It doesn't reject the formula; however, when I plug it in to the cell where I'm trying to populate the specific value, all I get is 0

=IF(J7="Supplier Escapes",5,IF(J7="Customer Escapes",10,IF(J7="Internal Escapes",30,0)))

I realized my issue and do thank you for sharing you're knowledge!

Originally Posted by DannyJ

This works fine for me. Don't see why you are having issues? Cell J7 would have to match 100%. I assume it does?

Gentlemen-
I am an idiot and yes it works, unlike my brain on occasion.