Results 1 to 6 of 6

Thread: listbox populated with Vlookup from multiple worksheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-11-2020, 05:30 AM #3
    jay6939
    jay6939 is offline
    Junior Member
    Join Date
    Jun 2020
    Posts
    10
    Rep Power
    0
    Thanks for reply DocAElstein.
    i have updated link for sample file.
    i have tried below Vlookup as well. but system gives me error of no mach type.
    Code:
    UserForm1.lstdatabase1.Column(5, (UserForm1.lstdatabase1.ListCount - 1)) = Application.VLookup(UserForm1.lstdatabase1(.List(.ListIndex, 5), Sheets("Cost").Range("A1:G1000"), 7, False))
    thanks
    Last edited by DocAElstein; 07-11-2020 at 11:47 AM. Reason: Do your code like this: [code] your code goes here ... [/code]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Vlookup on multiple matches
    By haiders7 in forum Excel Help
    Replies: 1
    Last Post: 08-10-2019, 05:08 PM
  2. Convert All Vlookup formulas to Index-Match in a worksheet
    By littleiitin in forum Download Center
    Replies: 0
    Last Post: 03-17-2016, 06:50 PM
  3. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 PM
  4. Word macro, Excel worksheet function VLOOKUP can not get to work
    By Chuck S48 in forum Word Help
    Replies: 4
    Last Post: 08-14-2012, 03:17 AM
  5. VLOOKUP with Multiple Results
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-26-2011, 10:29 PM

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
  •  

Forum Rules