+ Reply to Thread
Results 1 to 3 of 3

If/and formula always returns the false result

  1. #1
    Registered User
    Join Date
    02-28-2025
    Location
    Vancouver, WA
    MS-Off Ver
    Excel Office 365
    Posts
    2

    If/and formula always returns the false result

    I am trying to write an if/and formula that scans the columns in the 'class list' sheet matching criteria in four of them and then returns the data in the fifth column of that row to the appropriate cell in each day of the week sheet. However, no matter how I structure it, it always returns the false value instead of the data from the class column that I want it to find and return. I have tried changing the order of of the columns in the formula. I have tried using absolute references and mixture of relative and absolute references.

    This is the formula I have entered: =IF(AND('Class List'!A:A='Location Specific Data'!F1,'Class List'!C:C='Location Specific Data'!A6,'Class List'!E:E='Location Specific Data'!F2,'Class List'!D:D='Location Specific Data'!F7),'Class List'!$B$182,"----------")

    I have attached the workbook.

    I want the formula to return the data from the class list sheet column B row 182 to the cell where the formula is on the Sunday sheet.

    Thank you, any assistance is greatly appreciated!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,975

    Re: If/and formula always returns the false result

    Welcome to the Forum Craigro!

    You have the right idea in terms of the logic but you can't do this with a simple IF function. And comparing times makes it even more complicated. And the times in column D of Class List are text, not times, making it even more complicated.

    This formula works and can be copied to any row or column

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 02-28-2025 at 08:25 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-28-2025
    Location
    Vancouver, WA
    MS-Off Ver
    Excel Office 365
    Posts
    2

    Re: If/and formula always returns the false result

    Excellent, thank you!

+ 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] Use a formula if my IF function returns a false?
    By LXPF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2019, 12:40 PM
  2. [SOLVED] Formula always returns False instead of value, Why?
    By p1awn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2017, 01:03 AM
  3. [SOLVED] Formula Returns False
    By Rain Quintero in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2015, 02:48 AM
  4. [SOLVED] Vlookup formula returns with False Result, How can I get the exact value ?
    By Midoya in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-21-2013, 04:34 AM
  5. Replies: 5
    Last Post: 12-09-2012, 11:04 PM
  6. isblank & vlookup formula returns #n/a result and incorrect result
    By helpmeplease333 in forum Excel General
    Replies: 5
    Last Post: 05-06-2012, 11:41 PM

Tags for this Thread

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