+ Reply to Thread
Results 1 to 2 of 2

Returning a Value from a different worksheet - It's been a long day

  1. #1
    Registered User
    Join Date
    06-27-2017
    Location
    England
    MS-Off Ver
    2016
    Posts
    13

    Returning a Value from a different worksheet - It's been a long day

    I have attached an example workbook with 2 examples.

    This is how it is intended to work.

    If one of the cells in worksheet 'Example' (example 2 for this instance) within an area - for example F5 - is marked with 'N' then on the other sheet 'Front Page UnderCon example 2' that regarding area (area 1 in this example) should be marked as 'Y'.
    However, if there is no 'N' stated in the 'example 2' sheet then the flag status (Front page sheet) should be 'N'
    Attached Files Attached Files
    Last edited by oblah; 07-25-2017 at 10:44 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,735

    Re: Returning a Value from a different worksheet - It's been a long day

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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] Long formula using IFERROR and VLOOKUP returning #NAME?
    By redimp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2013, 09:08 AM
  2. [SOLVED] Long IF/AND Formula Returning #VALUE Error
    By ImHorhay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2012, 02:15 PM
  3. returning contracts over 12 month long
    By TTej in forum Excel General
    Replies: 2
    Last Post: 04-29-2008, 03:44 PM
  4. Returning one text value in a long list?
    By news.zen.co.uk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2005, 05:35 AM
  5. Returning one text value in a long list?
    By news.zen.co.uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  6. Mod Function Returning Long
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2005, 04:05 PM
  7. Problem with VBA returning the contents of a long formula.
    By alfred.vachris@gmail.com in forum Excel General
    Replies: 2
    Last Post: 02-22-2005, 09:06 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