Question regarding looking up values
Results 1 to 4 of 4

Thread: Question regarding looking up values

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Question regarding looking up values

    Hi Guys I have a question regarding lookups. I am using this code to do an index and match. the Mon_qu_sa_A are named cells / ranges.

    The code essentially works as intended with one exception the variable intPmtFreq in the formula once vba is ran says just monthly and so the cell shows #NAME ?. I can fix this manually by putting "" around monthly so monthly becomes "monthly". but how do I get vba to automatically put "" around the variable.


    ActiveCell.Formula = "=INDEX(mon_qu_sa_A,MATCH(" & intPmtFreq & ",MMQSAA,0),MATCH(" & monthCheckPmts & ",inv_horiz,0))"

  2. #2
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question regarding looking up values

    Try

    MATCH(""" & intPmtFreq & """,MMQSAA,0),
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  3. #3
    New Member
    Join Date
    Jun 2018
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question regarding looking up values

    worked great thank you

  4. #4
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question regarding looking up values

    You're welcome.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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