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 |
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 |
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 |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com