Set LookupRng1 = Workbooks("vendor1.xls").Names("").RefersToRange

I need b96:c124 ans the range for the lookup and this error out. What needs
to be between the "". ??????

Please advise