+ Reply to Thread
Results 1 to 3 of 3

Vloopup cant make it work

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,050

    Vloopup cant make it work

    HI I have problem with a vlookup in excel 2013. cant make it work IN cell A10 Sheet invoice 1 i have a dropdown menu. refer to column A in sheet Customers . Its the customer names. In the next cells in Sheet Invoice 1 A11 to A14 i need the remaining info for this customer. So i need a vlookup in these cells- A11 is the address, A12 is the post number and town, A13 is the telefone number and finally A14 is the vat number.

    Please have a look at below test sheet. Maybe more easy to see there. And upload it with the nessasary changes please-

    Thanks in advance
    Abjac
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,406

    Re: Vloopup cant make it work

    named ranges:
    Adresse =Customers!$B$2:$B$3
    CustomerBase =Customers!$A$2:$E$3
    Kundenavn =Customers!$A$2:$A$3
    Moms =Customers!$E$2:$E$3
    Postnuimmer =Customers!$C$2:$C$3
    Telefon =Customers!$D$2:$D$3

    Dropdown List ---> =Kundenavn
    looup and return based on name:

    A11 =INDEX(CustomerBase,MATCH($A$10,Kundenavn,0),2)
    A12 =INDEX(CustomerBase,MATCH($A$10,Kundenavn,0),3)
    A13 =INDEX(CustomerBase,MATCH($A$10,Kundenavn,0),4)
    A14 =INDEX(CustomerBase,MATCH($A$10,Kundenavn,0),5)
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,050

    Re: Vloopup cant make it work

    Hi protonLeah. I just checked it and it work like a charm. Thanks allot for your help really appreciated.

    Sincerely

    Abjac

+ 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] F4 doesn't work only in excel, how to make it work again?
    By Dave H in forum Excel General
    Replies: 1
    Last Post: 02-26-2014, 11:22 AM
  2. [SOLVED] How to make the macro work for all rows in the work sheet
    By Valli nayaki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2013, 10:43 PM
  3. Vloopup VBA help
    By craigmck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2011, 10:59 AM
  4. Excel 2007 : Match using Index or Vloopup for value
    By Jerseynjphillypa in forum Excel General
    Replies: 3
    Last Post: 10-16-2011, 09:35 PM
  5. [SOLVED] VLOOPUP
    By Fran in forum Excel General
    Replies: 6
    Last Post: 06-08-2006, 09:25 AM
  6. How to convert VLOOPUP error value #NA to 0?
    By Rex in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2006, 08:30 AM
  7. Spin button in a work sheet - how do I make it work?
    By mike_l_moore@msn.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1