Results 1 to 6 of 6

vlookup giving #N/A results

Threaded View

  1. 06-18-2014, 12:03 AM #1
    Jazzzbo
    Jazzzbo is offline
    Registered User
    Join Date
    09-14-2010
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2007
    Posts
    45

    vlookup giving #N/A results

    I've been using vlookup for years. Recently, it has stopped working properly for me.
    I have two sheets in the same file. When I use vlookup from sheet 1 to find a matching value on sheet 2 (Lawyers), I get #N/A in all cases.

    My cell formula is =
    Formula: copy to clipboard 
    vlookup(M9,Lawyers!A2:E50,3)


    Could someone please shed some light on this for me?
    Attached Files Attached Files
    Last edited by Jazzzbo; 06-18-2014 at 12:34 AM. Reason: Adding Workbook
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup giving Wrong Results
    By timbo1957 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-15-2013, 08:18 AM
  2. Partial Match Query - VLookup not giving accurate results for some obvious matches.
    By Embryo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2013, 08:46 AM
  3. VLOOKUP not giving apt results....
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2012, 04:36 AM
  4. [SOLVED] Using Index Match or Vlookup giving unexpected results on imported data
    By jacob@thepenpoint in forum Excel General
    Replies: 2
    Last Post: 07-03-2012, 05:49 PM
  5. Drop Down Box / VLookup not giving results
    By waki01 in forum Excel General
    Replies: 4
    Last Post: 01-08-2009, 05:04 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1