Pravina
10-11-2017, 04:50 AM
Hi ,
I have created below vba code. its running but showing result as value error. Please correct it.
Sub stdsuppliername()
Range("au13") = [VLOOKUP(sheets("Paste FER").RANGE("G87")&"*"&sheets("Paste FER").RANGE("S87"),CHOOSE({1,2},Sheets("Lookup Table").range("AQ1:AQ233")&sheets("Lookup Table").range("AR1:AR233"),sheets("Lookup Table").range("AS1:AS233")),2,0)]
End Sub
I have created below vba code. its running but showing result as value error. Please correct it.
Sub stdsuppliername()
Range("au13") = [VLOOKUP(sheets("Paste FER").RANGE("G87")&"*"&sheets("Paste FER").RANGE("S87"),CHOOSE({1,2},Sheets("Lookup Table").range("AQ1:AQ233")&sheets("Lookup Table").range("AR1:AR233"),sheets("Lookup Table").range("AS1:AS233")),2,0)]
End Sub