Results 1 to 12 of 12

Lookup formula not working on certain cells

Threaded View

  1. 12-02-2013, 07:40 PM #1
    Fletch74
    Fletch74 is offline
    Forum Contributor
    Join Date
    11-11-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Lookup formula not working on certain cells

    I have extracted some data from a database and have a situation where I want to display the vehicle franchises. Sometimes I have to display multiple franchises, so I have added that combination to the lookup table, however on some occasions it is not working...

    Can anyone give me a reason why I can't get this to work? I have attached an example below. The main error seems to be in cell C4!

    Thanks for the help
    Attached Files Attached Files
    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. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  2. Using the lookup formula but is not working correctly
    By susiesc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2013, 03:38 PM
  3. v lookup formula not working?
    By Lornabol in forum Excel General
    Replies: 6
    Last Post: 04-19-2011, 01:46 PM
  4. same lookup function working in some cells not others
    By Jerhansen277 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2007, 04:05 PM
  5. LOOKUP formula not working right
    By pdgaustintexas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2006, 11:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1