+ Reply to Thread
Results 1 to 2 of 2

How to create external reference in Excel to refer to another sheet use if function

  1. 01-20-2020, 01:56 AM #1
    eddie01001
    eddie01001 is offline
    Registered User
    Join Date
    06-05-2019
    Location
    new york, usa
    MS-Off Ver
    2007
    Posts
    8

    How to create external reference in Excel to refer to another sheet use if function

    How to create external reference in Excel to refer to another sheet use if function

    i have a if function like this
    =IF('sheetX'!D4+E4<3,"yes","no")


    the result is not right which is not D4+E4

    and i check the formula again it become =IF(sheetX!D4+E4<3,"yes","no") by itself
    why? how to fix it? please help

    thanks
    Reply With QuoteRegister To Reply
  2. 01-20-2020, 01:59 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,505

    Re: How to create external reference in Excel to refer to another sheet use if function

    Do you mean this?

    =IF(sheetX!D4+sheetX!E4<3,"yes","no")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    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. Reference data from other sheet, refer to date and then text for confirmation.
    By chrislkc in forum Excel General
    Replies: 21
    Last Post: 12-21-2018, 11:29 AM
  2. Dynamic reference formula to refer to range in open sheet
    By ibr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2018, 04:27 PM
  3. Create an external reference (link) to a cell range in another workbook WITH relative path
    By juanda77 in forum Excel General
    Replies: 0
    Last Post: 09-23-2013, 05:59 PM
  4. refer multiple external csv files returns #VALUE! error in vlookup function
    By dryice1993 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 06:21 AM
  5. VBscript function to copy rows from datasheet in qtp to an external excel sheet
    By laecy123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2009, 09:32 AM
  6. refer to drop down item as a sheet reference in a formula
    By milkman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2006, 03:15 PM
  7. Create an external reference link with embedded variable
    By Greentree in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2005, 03:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1