+ Reply to Thread
Results 1 to 2 of 2

Multiple conditions from siffreent sheets that print the results from a diffrent cell

  1. #1
    Registered User
    Join Date
    09-02-2014
    Location
    Oklahoma, USA
    MS-Off Ver
    2003
    Posts
    1

    Multiple conditions from siffreent sheets that print the results from a diffrent cell

    I have two different Sheets in a Workbook. I am trying to write a condition where if cell B1 Sheet 2 = cell A2 Sheet 1, and cell B2 Sheet 2 = cell B2 sheet 1, and cell A3 sheet 2 = cell C2 sheet 1, then cell B3 sheet 2 would display the text from cell D2 sheet 1. How would this be written? I have been unable to make it work. I have access to newer versions of Excel if needed.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Multiple conditions from siffreent sheets that print the results from a diffrent cell

    Try the below in B3 on Sheet 2.

    =IF(AND('SHEET 2'!B1='SHEET 1'!A2,'SHEET 2'!B2='SHEET 1'!B2,'SHEET 2'!A3='SHEET 1'!C2),'SHEET 1'!D2,"What you want here if the three conditions do NOT match")

+ 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. Print Rows On Diffrent Sheets
    By PsychoForJesus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2013, 10:34 AM
  2. Replies: 3
    Last Post: 01-30-2013, 07:59 PM
  3. [SOLVED] Pull data from a single Cell in many diffrent sheets to the summary sheet
    By iancghln in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2012, 02:24 PM
  4. [SOLVED] Rank results in two diffrent blocks
    By allana13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 11:28 AM
  5. Print sheets based on filtered results from multiple workbooks
    By Lungfish in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2011, 04:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1