Results 1 to 8 of 8

Return an entire row based upon one cell result in each row

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    16

    Return an entire row based upon one cell result in each row

    Hi all,

    This one is hard for me but would be basic for the experts here. No macros please.

    I've set this up so that column AB has a number corresponding (from a Vlookup) to each month 1-12 for "Jan"-"Dec" and a 0 for "None"

    I'm looking for a formula in the January tab to output the results oof the row from AC through to BB in each of the different tabs for the corresponding months.
    The end result being for instance anything with a 1 for column AB in "Master" will be in the January tab.

    Thank you so much in advance. File attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-16-2018, 11:30 PM
  2. [SOLVED] Return result in third cell based on two cells with different conditions required
    By dvtexcel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-06-2016, 05:35 AM
  3. [SOLVED] Return a Result Based on First Word of Cell
    By sillyevi in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-10-2014, 10:37 PM
  4. sort entire row based on formula result in Column D
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 12:59 AM
  5. [SOLVED] Return result from a table based on two other cell results
    By jgregory43 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2013, 11:01 PM
  6. needing to find largest value in array, then return entire row associated with result
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-15-2009, 12:32 PM
  7. return array result in cell based on comparing dates
    By Ruthki in forum Excel Formulas & Functions
    Replies: 51
    Last Post: 09-06-2005, 12:05 PM

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