+ Reply to Thread
Results 1 to 2 of 2

Need to apply a Vlookup formula from VBA to excel in an array

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Phoenix, Arizona
    MS-Off Ver
    2010
    Posts
    13

    Need to apply a Vlookup formula from VBA to excel in an array

    Looking into a solution to adding a vlookup formula from VBA that pulls data from a network in an array
    Need to setup the "Cells" (row, column) in a for/next loop along with the formulas VLOOKUP cell location
    These basically need to both move down one cell for each next in the loop.

    I have gotten a manual formula working shown below as an example of what the next step in the array needs to be.


    Please Login or Register  to view this content.
    Last edited by jmacinnees; 10-03-2014 at 10:28 PM. Reason: code tags added

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Need to apply a Vlookup formula from VBA to excel in an array

    Hi, jmacinnees,

    why do you want to do this in an array?

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. [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
  2. Replies: 1
    Last Post: 12-11-2012, 08:55 AM
  3. How to apply ISERROR in an Array Formula
    By kborgers in forum Excel General
    Replies: 4
    Last Post: 01-13-2012, 03:38 PM
  4. Using VLOOKUP to apply an ARRAY formula
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2008, 10:22 PM
  5. 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

Tags for this Thread

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