Help with Multiple Function in One Cell! ??

[watson150]

Hi everyone,

Can anyone assist?

I have a spreadsheet where column A lists the months of the year, Column B lists quantities for that month. Column C is blank and Column D, Has a dropdown box of a list of the months (data validation).

I have worked out the calculation/formula for Column C to return the value of quantity against a month, if that month is selected on dropdown. So =IF(F1=A1,B1)



But I want to have that same formula in this cell to occur for every month not just the one. So that no matter what month I select fro mthe drop down, it will return the value next to the corresponding month. Is this possible?

[watson150]

Formula.JPG

Here is an image to assist with my query

[shg]

One way:

	A	B	C	D	E	F
1	Month	Qty		Month	Qty
2	January	19		March	18	E2: =VLOOKUP(D2, A2:B13, 2, 0)
3	February	13
4	March	18
5	April	48
6	May	35
7	June	16
8	July	45
9	August	49
10	September	26
11	October	43
12	November	33
13	December	13

[Phuocam]

Try ...

=VLOOKUP(F1,A1:B20,2,0)

[watson150]

Thanks so much everyone! Worked perfectly!

[shg]

You're welcome.