Can you make more than one word equal to a value in Excel? I know this formula =VLOOKUP(C1,A$1:B$20,2,FALSE) will work for one word, but not multiple words. I need it for multiple words. I need the cell to use multiple words in other cells to equal out one price. Example: Lettuce - $0.05, Tomato - $.06, Onion - 0.04..etc and for the cell to add up all the words and the prices associated with them. Thank you.