Formula not populating result in the cell instead can see the formula only

[ThrottleWorks]

Hi,


I have a file, I am trying to write below formula in the worksheet.


=VLOOKUP(L2,'Broker Mapping List'!A:B,2,0)


When I enter the formula, it does not populate the results, instead I see the formula only.


To get the result I have to do Alt D E D F, this gives me the result for vlookup.


The problem is I am entering this vlookup by macro so can not do Alt D E D F.


Can anyone please tell me how to resolve this problem.


P.S. - I am using following code to populate the vlookup.


Range("m2").Value = "=VLOOKUP(L2,'Broker Mapping List'!A:B,2,0"

Range("m2:m" & endrow).FillDown

 

[Hui]

Try setting the Formula property not the Value property using

Range("M2").Formula = "=VLOOKUP(L2,'Broker Mapping List'!A:B,2,0)"

 

[ThrottleWorks]

Hui Sir, sorry for late reply.


Thanks for the help, but it is not working after changing to formula also.


Even I write a simple formula like sum manually in the sheet, I have to do Alt D E D F to get the results.

 

[Sara]

Hi there


This might help

http://chandoo.org/wp/2010/04/12/excel-formulas-are-not-working/

 

[jeffreyweir]

Interesting. I never knew about the TEXT thing at that link. This has bugged me for years. Thanks Sara.

 

[ThrottleWorks]

Hi Sara, thanks a lot for the help, this is working.

Sorry for late reply, have a nice day ahead.


@Jeff how are you Sir !