If Then Statement?

**xlsfreak** · 01-19-2008, 12:57 PM

Hello Excel-O-Philes how are you? I am new to the forum and have a quick question, maybe this can be done, maybe it cannot. Either way any insight would be greatly appreciated.
Here is my example:
Lets say I have a validated list of all 12 months in Cell A1. In cells lower down the page there are two columns a list of months, and a list of numbers that correspond with each month.
My question is: Can I build a formula in B1 that will select the corresponding numbers to each month based on the choice in the list in A1 that I make? Maybe somthing like "=IF((A1='January')THEN(Value C2)????

I know this is an impossible formula, however any insight would be greatly appreciated. Thank you so much in advance for any help.

Take care
Cort-

**NBVC** · 01-19-2008, 01:30 PM

Take a look at Vlookup help in Excel help files.....

e.g. = Vlookup(A1,B100:C200,2,FALSE) where B100:C100 is your table of months and corresponding values to retrieve