Results 1 to 5 of 5

Thread: How to do Vlookup of 2 argument

  1. #1

    How to do Vlookup of 2 argument



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am trying to get a Vlookup that has 2 arguments in the formula where it looks one "Location" and "Client ID" from Sheet 2.


    Vlookup(Location&Client ID,In Sheet 2, Lookup State,False)


    See attachment
    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    740
    Articles
    0
    Take a look at the attached:
    Attached Files Attached Files

  3. #3
    Thank you for help, I was wondering if there anyway to incorporate a VBA code with the above formula?

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    740
    Articles
    0
    Quote Originally Posted by shahid5788 View Post
    Thank you for help, I was wondering if there anyway to incorporate a VBA code with the above formula?
    VBA has its own functions and processes which are more extensive than Excel, but at the same time you can invoke any of the Excel formulae within VBA, and assign the result to a cell or variable.
    Last edited by Hercules1946; 2017-06-19 at 09:58 PM.

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,275
    Articles
    0
    cross posted without links:
    https://www.excelforum.com/excel-gen...-argument.html
    http://windowssecrets.com/forums/sho...-of-2-argument
    https://www.mrexcel.com/forum/excel-...-argument.html

    shahid5788, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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