Results 1 to 1 of 1

VLOOKUP not working correctly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    VLOOKUP not working correctly

    I have attached my workbook, because this issue is a little hard to explain.
    On the Search sheet I have several vlookup formulas which return records based on the search criteria entered into the search cells at the top. When no search criteria is entered it correctly displays all 317 records on the Return Data sheet (from rows 11 to 327). The search is correctly displaying the records that meet the search criteria when criteria is added, however when any kind of search is performed it also displays the first record on the Return Data sheet in row 328 and below. How can I prevent this from happening? It seems I need to tell the code to do nothing when the record it is looking up is blank.

    This is an example of the formula im using in one of the rows:
    =IFERROR(VLOOKUP(INDIRECT("ReturnData!A"&ROW()-5),ReturnData!$B$6:$K$49969, 3, FALSE),"")

    Thank you for your time,
    James
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF VLOOKUP isn't working correctly
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-30-2013, 10:04 AM
  2. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  3. [SOLVED] Vlookup in a table -not working correctly-HELP!!
    By barbibchn in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-14-2013, 07:49 PM
  4. VLookup/IF Statements and Multiple Variable Lookup Not Working Correctly
    By gustafsoni in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2007, 08:50 AM
  5. VBA not working correctly
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-28-2006, 03:15 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