I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that would read a certain text in a cell containing multiple words and that word will automatically correspond to a value to the next cell.
Example:
Let's say the word Ball is equal to 10, Toy is 15, and Bag is 5.
A cell will contain multiple text like:
Basket Ball 6" NYC
if the word "Ball" in cell A1, the value 10 should be in B1 or if the word "Bag" is in A1 the value 5 should be in B1.
Hope someone can help me. I would really appreciate your help.
BTW, thank you for your help. I tried removing other words in the cell and just left the word "ball" and it showed me the corresponding value in B1.
I guess the question I wanted to ask was, is there another function that I can add to the formula to look for the specific word in the cell like SEARCH or FIND and still produce the right value in B1.
I guess the question I wanted to ask was, is there another function that I can add to the formula to look for the specific word in the cell like SEARCH or FIND and still produce the right value in B1.