rong3
10-19-2017, 09:20 PM
Hi all , I have a formula Vlookup with multi condition like this:
=VLOOKUP(B3&E3&G3,CHOOSE({1,2},B:B&E:E&G:G,C:C),2,0)
It works if Ctrl Shift Enter on formula to formula array.
So I rewrite it into VBA like
Workbooks(wb_name).Range("C3").FormulaArray="=VLOOKUP(B3&E3&G3,CHOOSE({1,2},B:B&E:E&G:G,C:C),2,0)"
But it only show formula and I must focus on it then Ctrl Shift Enter to display value return.
How to solve this issuse. Please help me.
=VLOOKUP(B3&E3&G3,CHOOSE({1,2},B:B&E:E&G:G,C:C),2,0)
It works if Ctrl Shift Enter on formula to formula array.
So I rewrite it into VBA like
Workbooks(wb_name).Range("C3").FormulaArray="=VLOOKUP(B3&E3&G3,CHOOSE({1,2},B:B&E:E&G:G,C:C),2,0)"
But it only show formula and I must focus on it then Ctrl Shift Enter to display value return.
How to solve this issuse. Please help me.