+ Reply to Thread
Results 1 to 6 of 6

IF statement with special scenario help

  1. #1
    Registered User
    Join Date
    05-03-2017
    Location
    CA
    MS-Off Ver
    210
    Posts
    61

    IF statement with special scenario help

    Is there some sort of formula that will looking to those particular columns and return same information from another column if Customer Name and Item are same for that particular line item.

    I need a formula that will look into column D and E and you can see that we have same information being shown but we have blank TO for last 2 rows.


    Please see attachment.


    Can someone please assist
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-30-2016
    Location
    Gillette, WY
    MS-Off Ver
    2016
    Posts
    220

    Re: IF statement with special scenario help

    Quote Originally Posted by usama5788 View Post
    I need a formula that will look into column D and E and you can see that we have same information being shown but we have blank TO for last 2 rows.
    Can you clarify. What column are you trying to calculate? What are your expected values, i.e. if you're trying to calculate the last two rows in Column C, what should be the output of the formula? Is the value "TO520" coming from data validation somewhere? I understand what you want to reference but I'm not clear on what you need the formula to do, exactly.

  3. #3
    Registered User
    Join Date
    05-03-2017
    Location
    CA
    MS-Off Ver
    210
    Posts
    61

    Re: IF statement with special scenario help

    Hi sorry for the confusion. I am trying to calculate in column C. Please see attached updated worksheet. As you can see highlighted cells in column C. I want a formula to return those information.
    Attached Files Attached Files

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: IF statement with special scenario help

    Try this
    Enter formula in C2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Registered User
    Join Date
    05-03-2017
    Location
    CA
    MS-Off Ver
    210
    Posts
    61

    Re: IF statement with special scenario help

    Hi Thank you for the formula. My main consistency that I am looking for in a formula is looking at "Customer Name" and "Item" as the main bases when doing the "search" becuase if those are same. Not my "Memo/Description". Since I have alot of information I need to have my "Customer name" and "Item" my main driving point.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,258

    Re: IF statement with special scenario help

    For the sample data in the file attached to post #1, the following array entered formula* returns the expected values based on the customer name and item:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Paste Special within If Statement
    By jonhigson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-19-2016, 08:08 AM
  2. How to copy, paste, delete to special cell with if-then-statement in csv.file?
    By Riva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 11:32 PM
  3. Scenario Manager displays same result for every scenario
    By terihoff in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 11-10-2012, 07:14 PM
  4. VBA for Paste special when IF statement is TRUE ?
    By archangel9999 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2012, 06:39 AM
  5. Replies: 0
    Last Post: 08-16-2012, 01:32 PM
  6. [SOLVED] If statement returning part of a cell between special characters
    By singerj6 in forum Excel General
    Replies: 7
    Last Post: 04-27-2012, 05:16 PM
  7. Add scenario to IF statement using "And"?
    By smcduffi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2011, 03:12 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