WHEN function?

[Scriv]

I tried search for this but the search tool excludes words like When....

Here is the situation. I have a drop down cell (A1 below) in which you can choose a month, and another cell (B1 below) which the shows the total cost for a given month.

Please Login or Register  to view this content.

I would like to produce a table as below, giving values in column D1 when cell A1 contains the different values in column C.

Please Login or Register  to view this content.

Is there a formula which I could enter in column D which would produce the values described, or would I have to manually change cell A1 and input the B1 outputs into column D?

I'm thinking it may be a sort of "equals B1 when A1 = C1" type of formula...

Thanks

[NBVC]

Maybe,

=IF(C1=$A$1,$B$1,"")

copied down

[Scriv]

That would only display a single value in column D and blanks for the rest of the rows.

I need excel to physically input all of the values in column C into cell A1, then record all of the outcomes of cell B1 in column D.

Any thoughts?

[Palmetto]

That would only display a single value in column D and blanks for the rest of the rows.

You did say A1 is a drop down. Anyway, since you want compare C1 to A1, you can only return a result if there is a match. The formula NBVC provided is exactly what you asked (maybe not what you intended).

I need excel to physically input all of the values in column C into cell A1, then record all of the outcomes of cell B1 in column D.

This is altogether another situation. You want the list of values in Column C to appear in a drop down in A1. Use Data Validation (List option) and reference the range of cells in column-C which hold the list of values.