Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF or Vlookup or.... Which is best for this example:
I have 12 months and a value tied to each one. I was wondering what the best
way is to place the value in a cell if another cell has one of the months. I assume I could put an IF statement in each cell I want the results in. For Instance, using the values below: IF A1="October",10, A1="November",11, A1="December",12, (etc,) would place the appropriate value in the cell(s) that have that IF statement. 1 = January 2 = February 3 = March 4 = April 5 = May 6 = June 7 = July 8 = August 9 = September 10 = October 11 = November 12 = December Should I use a long IF statement that lists each of the 12 months (assuming an IF statement can do that), or try a Vlookup function (which I'm not that familiar with?) Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
VLOOKUP not working | Excel Worksheet Functions | |||
Using Cell references in VLookUp | Excel Worksheet Functions |