+ Reply to Thread
Results 1 to 3 of 3

Need to apply advanced array vlookup formula in vba code

  1. #1
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Need to apply advanced array vlookup formula in vba code

    Dear Expert,


    In vba coding, I'm trying to get multiple values from an array using an advanced vlookup formula. But I'm unable to do so because I can't find it on Google or YouTube. Please assist me in assigning the formula below to the "with statement" in vba coding.

    In Columns (U, V, W, X) Formula: =VLOOKUP(R2,Mapping!A:AB,{13,15,21,25},FALSE)

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-19-2022
    Location
    TBD
    MS-Off Ver
    O365
    Posts
    46

    Re: Need to apply advanced array vlookup formula in vba code

    Hi Pankaj jaswani,

    Please try:

    1. For dynamic array
    Please Login or Register  to view this content.
    2. For non-dynamic array
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Re: Need to apply advanced array vlookup formula in vba code

    Thank you so much!! @chocolate_kitten

+ 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. How to apply Vlookup in Same column with diffrent Table array
    By Merrysa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2019, 09:24 AM
  2. [SOLVED] VBA code to Remove duplicates and apply vlookup and sumif
    By mangesh.mehendale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2015, 12:14 AM
  3. Need to apply a Vlookup formula from VBA to excel in an array
    By jmacinnees in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2014, 01:35 AM
  4. [SOLVED] Need to apply vlookup in current sheet with table array from another workbook
    By deepak.sirsale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2014, 04:26 AM
  5. [SOLVED] How to apply code to all sheets in an array
    By seethepuck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2013, 03:13 PM
  6. Using VLOOKUP to apply an ARRAY formula
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2008, 10:22 PM
  7. Not able to apply VLOOKUP Lookup value present in Table array
    By mustafamsaleem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2006, 10:12 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