+ Reply to Thread
Results 1 to 5 of 5

MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    malaysia
    MS-Off Ver
    2010
    Posts
    30

    MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

    Hi,

    Column N: Im using vlookup, but i prefer to change it to formula below since macro running slow if i using it. But the formula didnt run as well. Can help?

    Im really a new beginner in VBA, my macro is auto recording. Can it be simplified?

    Activecell.FormulaR1C1= _ " IF(H3="O6","6%",IF(H3="H6","6%",IF(H3="OD","6%",IF(H3="OA","6%",IF(H3="OC","6%",IF(H3="I6","6%",IF(H3="IM","6%",IF(H3="IB","6%",IF(H3="IH","6%",_
    IF(H3="IA","6%",IF(H3="IC","6%",IF(H3="IR","6%",IF(H3="HR","6%",IF(H3="IL","0%",IF(H3="IN","0%",IF(H3="IO","0%",IF(H3="IS","0%",IF(H3="IX","0%",IF(H3="OO","0%",IF(H3="OX","0%")))))))))))))))))))) "
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

    Does this help?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Montreal, QC
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

    Hello,

    This is another way to see your formula above
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or you can use this formula with Vlookup
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-23-2014
    Location
    malaysia
    MS-Off Ver
    2010
    Posts
    30

    Re: MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

    Hi,

    Thank You Thank you very much for sharing your knowledge. Help a lot

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

    You're welcome. Glad to help out and thanks for the feedback and the rep. Please comply with Forum Rules and mark this thread as SOLVED. Review the link below for guidance.

    http://www.excelforum.com/forum-rule...rum-rules.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro formula:write formula manually instead of vlookup
    By tieyanna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2015, 08:42 AM
  2. Override formula with a manually entered number, but keep formula stored
    By EmmaWied in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2015, 07:52 PM
  3. [SOLVED] help needed to write a vlookup, match or combination of both formula
    By spittingfire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2015, 09:31 AM
  4. [SOLVED] How to write an array formula with vlookup
    By bberger1985 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2014, 10:35 AM
  5. Replies: 33
    Last Post: 02-14-2013, 01:51 AM
  6. Macro to write Vlookup formula with variable column index
    By Ashali in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2012, 09:40 PM
  7. Clueless as to how to write VLOOKUP formula
    By moodwalker in forum Excel General
    Replies: 3
    Last Post: 06-06-2005, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1