Results 1 to 3 of 3

If/and formula always returns the false result

Threaded View

  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!

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