+ Reply to Thread
Results 1 to 3 of 3

Formula works except for one cell

  1. 03-02-2025, 02:30 PM #1
    rafcaf
    rafcaf is offline
    Registered User
    Join Date
    09-22-2013
    Location
    Riverton Wyoming
    MS-Off Ver
    Microsoft Home Office 2024
    Posts
    52

    Formula works except for one cell

    I am using vlookup to pull data from monthly tabs into a 30 day tracking tab.

    The formula: =IFERROR(1/(1/VLOOKUP($A32,INDIRECT($I32&"!a$3:g$33"),COLUMNS($A$1:C$1),0)),NA())

    works everywhere but the cell C32 in the 30 day tab.

    I cannot see any formula differences between C32 - G32 or any for the formulas above it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-02-2025, 02:33 PM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Formula works except for one cell

    There's nothing wrong with the formula, you just need to change the cell format to time.
    Reply With QuoteRegister To Reply
  3. 03-03-2025, 01:37 AM #3
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,289

    Re: Formula works except for one cell

    Need to change format to Time.
    In March25 sheet on 3 March 2025 no any data.
    Your Formula is ok

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Formula only works on first cell specified in range (AGAIN!)
    By Bensley in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-26-2018, 08:52 AM
  2. [SOLVED] Formula only works on first cell specified in range
    By Bensley in forum Outlook Formatting & Functions
    Replies: 15
    Last Post: 03-20-2018, 04:34 AM
  3. [SOLVED] Formula works in one cell, and then identical formula does not work in next cell! What?!
    By unclejemima in forum Excel General
    Replies: 8
    Last Post: 11-29-2017, 12:36 PM
  4. Counta(Offset...)) works in cell but not named formula; cell references are not relative.
    By January1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2014, 02:42 PM
  5. [SOLVED] Formula which works in one cell but not another?
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-14-2014, 12:39 PM
  6. Formula only works for the first cell with that value
    By Tindall80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2013, 12:49 PM
  7. formula works when referring to one cell but not to another
    By Nicci in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-07-2006, 09:10 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