Page 1 of 1

Problem with lookup

Posted: Thu Mar 05, 2015 7:28 pm
by jalin14
I wrote the following code:

XLS[0].AsFormula[2+3,Row]:= 'LOOKUP(HojaLecturas!'+A3+',Costos!$A$2:$B$244)';

when I open the sheet with Excel appear: #¿NOMBRE?

So, changing nothing, I click the Fx button on the cell , close the window and the function appear correctly

What am I missing in my code?

Thank you

Re: Problem with lookup

Posted: Fri Mar 06, 2015 8:35 am
by larsa
Hello

Please provide a code sample that will compile.