+ Reply to Thread
Results 1 to 6 of 6

Self Creating VLOOKUP

  1. #1
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Self Creating VLOOKUP

    Hi Everyone!

    Attached is a example of what im doing, the fields are populated by a VLOOKUP against another worksheet in the workbook.

    Using the example attached you can see that if the vlookup doesnt have any data (so blank row in the other sheet) it displays all 0's when i paste special.

    WHAT IM TRYING TO ACHIEVE:

    Normally i would manually have to go into the spreadsheet and delete the rows that arent populated by data so in example this would be rows 208-216.

    Is there a way with VBA to only create the Vlookup Boxes or 'Template' for the amount of rows that contain data in the other worksheet?

    Thus no longer having to manually remove the lines and also not having to create more in the event that there is more than the number of 'boxes' i already have?

    Thanks!

    sample.jpg

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Self Creating VLOOKUP

    Try this

    If(vlookup()=0,"",vlookup())

    All the value with "0" will be replaced with blank.
    Instead of "" you can use any other value ie "-", etc
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Re: Self Creating VLOOKUP

    Thanks raj, not what im looking for though.

    I am wanting to create the vlookup on a loop for however many rows of data the vlookup has, i can do this using a simple count function to get the number however not sure how to create the 'templates'

    Give me a second i will upload a sample book to make more sense.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: Self Creating VLOOKUP

    If you use =iferror(vlookup(),""), copied down way past where you think you will need it, it will just sit there, sorta invisible, until data in the other sheet activates it.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Re: Self Creating VLOOKUP

    Dont think i explained myself properly...

    So i am wanting to create a vlookup on a loop using my 'box' as a template as shown on the example book ive attached to this post

    All of your answers get rid of the values WITHIN the vlookup template, which still doesnt solve the problem of me having to manually go in and delete the rows or 'templates' that dont contain data.

    sample.xlsx

  6. #6
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Re: Self Creating VLOOKUP

    anyone able to assist me on this?

+ 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. Excel 2007 : Creating a VLOOKUP formula
    By Edloverr in forum Excel General
    Replies: 4
    Last Post: 09-06-2011, 12:08 PM
  2. Creating tables for =vlookup and =if
    By soysoy05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2011, 12:39 AM
  3. Help Vlookup on creating report?
    By excelator in forum Excel General
    Replies: 6
    Last Post: 12-03-2010, 05:20 AM
  4. VLOOKUP creating blank rows
    By wbcsc in forum Excel General
    Replies: 3
    Last Post: 07-13-2010, 03:40 PM
  5. Help creating a VLookup table?
    By wahiba in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2008, 05:27 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