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 |
#2
|
|||
|
|||
Try
=IF(A2="","", =VLOOKUP(MONTH(A5),Lookup!$A$13:$B$24,2,FALSE)) Another way to copy formulas down would be to copy the formula in B2. In the name box (above row numbers and to the left of column A) enter B3:B100, or whatever range you require. Paste -- Regards Roger Govier "Dmorri254" wrote in message ... 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 |
#3
|
|||
|
|||
Part 2
You could have a worksheet_change event that when something is entered in col A the formula is automatically copied in. -- Don Guillett SalesAid Software "Dmorri254" wrote in message ... 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 |
Reply |
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 |