+ Reply to Thread
Results 1 to 16 of 16

Vlookup Problem

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Post Vlookup Problem

    I got some problems to get my Vlookup in a good order

    Clientname company check ''Freshbooks'' must check in Debiteuren for the number and that will be posten on "ouput" Cell A


    I need to put this in a VBA script can someone help me with this.

    Thank you,

    Test1.xlsm

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    You are missing the Last Argument of the Vlookup (i.e.) after column index number you have to mention you have to mention false or 0 to make the exact comparison.

  3. #3
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    The vlookup code i got now works for me.
    But i don't know to setup the last one code for my client name

    I need to have my ""sheet Freshbooks'' Clientname to compare if its there in Sheet'Debiteuren' and the Right nummber 10000,10001 must appear on sheet 'Output' on the right cell

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    We need exact cell/range references with sheet name and the expected result for giving the solution

  5. #5
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    ok i will explain step for step..i'm real noob with this.

    So on sheet"Export Freshbooks" i got Cell:A clientnames ...the names must be linked to Sheet'Debiteuren'
    Each Client got his own number so the name and numbers must be linked Example: 3rdbase=10001

    The outcome must appear on Sheet 'Output' on cell A on when i update it with my Macro.


    Thank you,

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    But the Column-A heading of Output sheet shows Client Name. Why you named it as Client Name instead of keeping it as Number?

    Please clarify....

  7. #7
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    When i send it in to my workers the need to see the name there to specify .
    it not my rule but ... i can change client name to debiteuren to.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    In Debiteuren Sheet

    Is it possible for you to move the Column-A Number to Column-B and Column-B Naam to Column-A?

    Because if you keep the data in that way then we can easily get the result with the use of simple vlookup in Output Sheet.

    If you interchange the data in the above mentioned way then you can use the below formula

    In A2 Cell of Output Sheet
    =IFERROR(VLOOKUP('Export Freshbooks'!A2,Debiteuren!A:B,2,0),"")

    Drag it down..

    Or

    If you want to get the result without changing the data structure then

    In A2 Cell of Output Sheet

    =IFERROR(INDEX(Debiteuren!A:A,MATCH('Export Freshbooks'!A2,Debiteuren!B:B,0)),"")

    Drag it down...

  9. #9
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    ok i changed the the Column-A Number to Column-B and Column-B Naam to Column-A
    and on A2 'Ouput' i did
    =IFERROR(VLOOKUP('Export Freshbooks'!A2,Debiteuren!A:B,2,0),"")

    but now i get this with both codes

    Capture.PNG
    Last edited by Shimazu; 02-21-2014 at 07:14 AM.

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    Please refer the attached file for details
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    Wow thank you so much 3 days work pffff

    One little thing now before i praise you to heaven
    how can i change the code =IFERROR(VLOOKUP('Export Freshbooks'!A2;Debiteuren!A:B;2;0);"") in a VBA ??

  12. #12
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    Add this code with your code....

    Please Login or Register  to view this content.

  13. #13
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    In the suggested code replace the A2:J wit A2:.A

  14. #14
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    Do i need to add this between my code? so in Forms ore module??

    i doesn't really works sorry i'm realy beginner with this

  15. #15
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Vlookup Problem

    Add it inside the forms existing update button code.

    Replying from mobile device so unable to add and show it to you.

  16. #16
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Vlookup Problem

    Thank you it worked now

    I only need to do one thing now
    if I need any further assistance i will contact you.
    You make my day Mate,

+ 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. Vlookup problem in a loop with cell property and variable cell problem (long title sry)
    By ExcelsiorLux in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2013, 10:38 AM
  2. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  3. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  4. vlookup problem and count problem
    By thy00123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2009, 04:31 AM
  5. [SOLVED] Vlookup problem
    By Big Jones in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 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