Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Autofill
Hi all! I've got this problem and it's really bugging me!! Say, I've got Sheet 1 (attached) and there's some formula (assume it's some VLOOKUP formula) on D3. I basically need some macro that would autofill the formula in D3 down to all the other cells in column D, EXCEPT for those cells with no corresponding value in the B column and those with "Total". Any help would be greatly appreciated. Thanks! +-------------------------------------------------------------------+ |Filename: Sheet 1.JPG | |Download: http://www.excelforum.com/attachment.php?postid=4019 | +-------------------------------------------------------------------+ -- uberathlete ------------------------------------------------------------------------ uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388 View this thread: http://www.excelforum.com/showthread...hreadid=483515 |
#2
|
|||
|
|||
Conditional Autofill
Instead of code, how about a formula to do exactly the same thing. It
works by nesting your VLOOKUP into an IF: =IF(AND(B1<"",ISNUMBER(SEARCH("total",D1,1))), your vlookup formula here,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |