1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup and Is number Formula using Vba code

Discussion in 'VBA Macros' started by Dinesh_Excel, Jan 12, 2019.

  1. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    145
    Hello Friends,

    Need help on running the below formula on columns CE and CF and CG using Vba.
    The range is dynamic in nature and not constrained to constant.

    Appreciate your help on the same.

    CE =VLOOKUP(AK2,'Country – Service HUB'!A:C,3,0)
    CF =VLOOKUP(AK2,'Country – Service HUB'!A:B,2,0)
    CG =IF(ISNUMBER(FIND("I",A2)),"Internal","External")

    Attached sheet for your reference.

    upload_2019-1-12_12-58-57.png

    Attached Files:

  2. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    145
    HI All,

    I am getting the following error while trying to enter a formula using vba.

    Appreciate your help

    upload_2019-1-12_19-48-34.png
  3. vletm

    vletm Excel Ninja

    Messages:
    4,645

    Attached Files:

  4. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    145
    Thanks Vletm..for highlighting the error.
    I could manage to crack the requirement for most of the scenarios but could not able to get the formula ....=IF(ISNUMBER(FIND("I",T2)),"Internal","External") in colunm CG.

    The reason for the getting it to run through vba is one of the requirement where it should automatically populate while there is a change in range.


    Appreciate your help..

    Attaching reference updated sheet.


    upload_2019-1-12_22-36-51.png

    Attached Files:

  5. vletm

    vletm Excel Ninja

    Messages:
    4,645
    Dinesh_Excel
    I see ...
    You skipped my hints
    as well as
    my given solutions.

    You wrote:
    The reason for the getting it to run through vba is one of the requirement where it should automatically populate while there is a change in range.
    You had there formulas and
    now You would like use VBA to do same formulas.
    What would change?
    Last edited: Jan 12, 2019

Share This Page