Pravina
10-11-2017, 04:03 AM
below code showing value error in au13
Range("au13") = [VLOOKUP(worksheets("Paste FER").RANGE("G87")&"*"&worksheets("Paste FER").RANGE("S87"),CHOOSE({1,2},WORKSHEETS("Lookup Table").range("AQ1:AQ233")&worksheets("Lookup Table").range("AR1:AR233"),worksheets("Lookup Table").range("AS1:AS233"),2,0)]
Range("au13") = [VLOOKUP(worksheets("Paste FER").RANGE("G87")&"*"&worksheets("Paste FER").RANGE("S87"),CHOOSE({1,2},WORKSHEETS("Lookup Table").range("AQ1:AQ233")&worksheets("Lookup Table").range("AR1:AR233"),worksheets("Lookup Table").range("AS1:AS233"),2,0)]