Results 1 to 6 of 6

Vlookup persistent #N/A error?!?!

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2019
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Vlookup persistent #N/A error?!?!

    Hi all,

    Been scratching my head over this one. Basically I'm trying to create a spreadsheet for my everyday use.

    The spreadsheet consists of doing a series of simple additions. Then what I want it to do is then use vlookup to look up the maximum value from my 8 equations then output the governing equation.

    I've tried formatting my cells to make sure they're all numbers/letters format. Then tried making sure there are no odd spaces etc. Then tried checking character length etc, but can't make it work!

    The bit I'm trying to output is in the 'Governing' cell which I've highlighted in a red box already. (To be more concise, I've determined that my max is 7.44kPa then I want it to output G + Ql + Ws,up? But keeps giving me the #N/A error)

    Any help is appreciated.

    Excel file attached.
    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] application vlookup error runtime error 1004, unable to get the vlookup property of the.."
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-05-2018, 12:03 PM
  2. How can I keep a formula persistent down a column?
    By gilligan8 in forum Excel General
    Replies: 9
    Last Post: 06-25-2014, 11:00 AM
  3. Formula not being persistent when copied
    By ks100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2013, 03:58 PM
  4. [SOLVED] Persistent decimal rounding
    By Trevasaurus in forum Excel General
    Replies: 4
    Last Post: 03-20-2013, 04:27 PM
  5. Making vlookup persistent
    By 91TwighlightGT in forum Excel General
    Replies: 15
    Last Post: 11-07-2011, 04:54 PM
  6. Persistent Formula / Graph
    By haysmj in forum Excel General
    Replies: 6
    Last Post: 11-18-2008, 10:38 AM
  7. Persistent Data in a Combo Box
    By The Hawk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2005, 06:06 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