+ Reply to Thread
Results 1 to 6 of 6

Formula for returning result based multiple reference cells

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    Newcastle Australia
    MS-Off Ver
    2010
    Posts
    3

    Formula for returning result based multiple reference cells

    Okay So I have a list which has been divided to column 1 and 2. I wish to have column 1 cell 1 as reference A & column 2 cell 1 as reference B.
    Then use these results to match my table (B1-J1 & A2-A100) which has components cell 1 in column and cell 2 in rows.

    If these match result back with a true value if not blank.

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

    Re: Formula for returning result based multiple reference cells

    Hi baasman73 and welcome

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB

  3. #3
    Registered User
    Join Date
    03-10-2015
    Location
    Newcastle Australia
    MS-Off Ver
    2010
    Posts
    3

    Re: Formula for returning result based multiple reference cells

    Hi BSB....Thanks for responding
    I have attached a sample of what I'm looking to achieve
    Excel Tester.jpg
    Attached Images Attached Images

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formula for returning result based multiple reference cells

    You were asked to post a workbook. Not a picture of one, which is not editable.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    03-10-2015
    Location
    Newcastle Australia
    MS-Off Ver
    2010
    Posts
    3

    Re: Formula for returning result based multiple reference cells

    Sorry About that Glenn....I'm a newbie
    Attached Files Attached Files

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

    Re: Formula for returning result based multiple reference cells

    Try this in B2 and copy right then down as required.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Or if you want the cells to show as blank (as per your original post) rather than FALSE (as per your example file) then use this.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB
    Last edited by BadlySpelledBuoy; 11-04-2018 at 03:21 AM.

+ 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] Returning multiple cells based on criteria of other cells
    By paulstuartbullock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2016, 06:19 PM
  2. Replies: 5
    Last Post: 12-14-2015, 01:00 PM
  3. [SOLVED] Returning a YES or NO based on the condition of multiple other cells
    By Coubs3 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-01-2014, 10:53 AM
  4. Replies: 7
    Last Post: 09-06-2013, 11:59 PM
  5. Replies: 1
    Last Post: 08-21-2012, 02:46 PM
  6. Returning multiple values in multiple cells based upon one input
    By ccoonsk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 10:01 AM
  7. Returning the result of a VLOOKUP as a cell reference?
    By MilkyQuail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2011, 03:45 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