If then multiple indexes and outputs

Is there a formula that I could use to look for matches (text) within one cell and place an option of values in one other cell?

I am trying to attempt to match 1 of 4 texts in one cell. Based on the text match a dollar value of 1 of 4 options will show in the other text.

 

Thank you,

 

Robert L.

By: Robert

Leave a Reply

Your email address will not be published. Required fields are marked *