Return value based on column with data

[dhd2005]

Hi all,

I'm not sure where I'm going wrong here, please help:

I am trying to make a column return a number based on another column. For example, if A1 is "Bread," I want B1 to return "10." If A2 is "Cake," I want B2 to read "25." I've been trying various IF formulas, and I'm coming up blank. This hasn't been working:

=IF(A1=Bread,10)

Part of the issue is that I'm sleep deprived, but what stupid mistake am I making? Thanks in advance for your help!

[NBVC]

If you have a several possibilities, it would be best to create a table on the side of all the possibilities for A1 and in adjacent column the associated values...

then simply:

=Vlookup(A1,$X$1:$Y$10,2,FALSE)

where X1:Y10 contains the above suggested table.... adjust as necessary.

[NBVC]

If it is only those 2 options..

Then : =IF(A1="Bread",10,IF(A1="Cake",25,""))

[dhd2005]

NBVC - Thank you so much. My most immediate problem was forgetting the quotation marks with my initial value; but both of your suggestions worked swimmingly. Thank you so much!