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