+ Reply to Thread
Results 1 to 4 of 4

#N/A and auto formula

  1. #1
    Registered User
    Join Date
    12-16-2022
    Location
    Cebu
    MS-Off Ver
    WPS Kingston
    Posts
    38

    #N/A and auto formula

    Hi guys,

    I was trying to remove #N/A with IFNA or IFERROR in column L but not getting it right.

    Another issue I'm having with my index formula I tried to replicate in K3. Instead of manually changing the numbers from 11 to 23 to 35 and so on I would like to have an autofill again

    K1 equals sheet 2 I11
    K2 equals sheet 2 I23
    K3 equals sheet 2 I35
    K4 equals sheet 2 I47
    K5 equals sheet 2 I59

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: #N/A and auto formula

    K4:
    =IFERROR(INDEX(Sheet2!I:I,11+12*(ROWS(K$4:K4)-1)),"")

    L4:
    =IFERROR(IF(OR(K4>VLOOKUP($J$4,$R$4:$S$6,2,0),K4>VLOOKUP($J$4,$R$4:$S$6,2,0),K4>VLOOKUP($J$4,$R$4:$S$6,2,0)),"Achtung",""),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-16-2022
    Location
    Cebu
    MS-Off Ver
    WPS Kingston
    Posts
    38

    Re: #N/A and auto formula

    Thanks again Glenn for your quick help. It eases my work and looks much better now _/\_

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: #N/A and auto formula

    Thanks for the feedback... you're welcome!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-evaluating: Auto Add after entering any value & display value in Formula Bar
    By pipsmultan in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-16-2019, 09:31 AM
  2. [SOLVED] Formula for Auto Change 0 With Blank and Auto Short To the Top Table
    By Blek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-23-2019, 12:08 PM
  3. Replies: 5
    Last Post: 02-15-2017, 08:28 AM
  4. Replies: 0
    Last Post: 07-10-2013, 11:06 AM
  5. Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  6. Auto Sort, Auto Lock, Auto Date & Time Stamp
    By suehatesyou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2010, 02:57 PM
  7. Auto Insert/Auto Formula?
    By Abacus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2006, 07:35 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