Results 1 to 6 of 6

How to remove " #N/A " as the end result instead of blank or zero.

Threaded View

  1. 05-19-2023, 03:24 PM #1
    j0SAND
    j0SAND is offline
    Registered User
    Join Date
    11-03-2020
    Location
    germany
    MS-Off Ver
    365
    Posts
    46

    How to remove " #N/A " as the end result instead of blank or zero.

    I am using a formula to award points to a column of score positions. The formula works but returns a " #N/A " for a playr who has not returned a score. I am using " "
    =VLOOKUP(E10;TEST!$P$3:$Q$14;2. I would like an adjustment to the formula that would return either a blank cell or a zero
    Attached Files Attached Files
    Last edited by j0SAND; 05-19-2023 at 03:39 PM. Reason: wrong file again
    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] Leaving A Cell "Blank" If The Result Of The Formula In It Is "#N/A"
    By Mvaldesi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2023, 02:33 PM
  2. If cell result is blank or empty (""), then go to next sheet and start copying from A2
    By wedzmer in forum Excel General
    Replies: 10
    Last Post: 06-22-2021, 10:52 AM
  3. [SOLVED] Need Result in "F", "T", "I", "TI", "IP", "TP" instead of "PASS" "FAIL"
    By vijubhau in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 01-23-2018, 10:20 AM
  4. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  5. Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank
    By DanBraden in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  6. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. if statement see "Male" or "Female" returning "Y" otherwise leave blank
    By qwervbnmasdf in forum Excel General
    Replies: 3
    Last Post: 12-14-2006, 01:36 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