| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Syntax Help
Hello,
In (B2) I have the following formula: =VLOOKUP(MONTH(A5),Lookup!$A$13:$B$24,2,FALSE) This gives me the month based on a date entry in (A1). I need to say if A1 is blank then B2 should remain blank as well. Also, is there a way to auto copy formulas down without manually pulling them down to the next row? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
| MS Query - Alias syntax | Excel Worksheet Functions | |||
| Vlookup Syntax Error | New Users to Excel | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| Previous Post - Correct Syntax Query | Excel Worksheet Functions | |||
Threaded Mode
