+ Reply to Thread
Results 1 to 4 of 4

Formula reliant on two cells with six possibilities

  1. 08-16-2017, 03:10 PM #1
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    65

    Question Formula reliant on two cells with six possibilities

    Hi

    I have a spreadsheet that I am using as a QA document that is populated from another tab.

    I have attached the possibilities and the outcome.

    Columns A & B are each possibility. Column C would be the outcome of the combination of that row.

    I have never created a formula with this many possibilities.

    Thank you in advance.

    Steve
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-16-2017, 03:20 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula reliant on two cells with six possibilities

    c2=A2&B2 and drag down

    o2=VLookup(M2&N2,$C$1:$D$7,2,0)

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 08-16-2017, 03:40 PM #3
    splottoman
    splottoman is offline
    Registered User
    Join Date
    08-01-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    65

    Re: Formula reliant on two cells with six possibilities

    Hi Oeldere,

    Works a dream. Thank you!
    Reply With QuoteRegister To Reply
  4. 08-16-2017, 03:43 PM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula reliant on two cells with six possibilities

    Thanks for the rep.

    You're welcome. We appreciate the feedback!

    Thanks for marking the question solved.
    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. [SOLVED] IF Formula reliant on two cells
    By splottoman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2016, 07:12 AM
  2. Conditional formatting, reliant upon text in two cells
    By Zookopf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2015, 09:13 AM
  3. [SOLVED] IF formula to match 2 different cells to 4 key possibilities
    By andyoungy in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-09-2015, 01:44 PM
  4. Formulas Reliant on multiple fields
    By splottoman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2015, 04:35 PM
  5. [SOLVED] Stop VLOOKUP returning '#N/A' & lOOKUP reliant on two cells
    By splottoman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2015, 03:09 PM
  6. Removing Duplicates between two cells reliant upon the formatting of the two cells
    By bethanj93 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-04-2014, 03:59 AM
  7. [SOLVED] Combine cells to have all possibilities of the combined cells
    By soroh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2012, 04:46 AM

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