Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array VLOOKUP lookup_Value does not increment
Is there a way to make B2 increment as the formula is filled down the columns?
As is, all formulas are identical. Is it because it's a array formula that prevents the increments? I increments on the sheet if done manually but not in the code. Thanks, Howard Sub VLook() Dim LRow As Long LRow = Cells(Rows.Count, "B").End(xlUp).Row Range("C2:F" & LRow).FormulaArray = "=VLOOKUP(B2,Sheet3!$B$2:$F$10,{2,3,4,5},0)" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup for multiple Lookup_value | Excel Programming | |||
VLOOKUP with multiple lookup_value's | Excel Discussion (Misc queries) | |||
VLOOKUP on partial lookup_value | Excel Discussion (Misc queries) | |||
vlookup lookup_value | Excel Worksheet Functions | |||
Vlookup(lookup_value) | Excel Worksheet Functions |