+ Reply to Thread
Results 1 to 2 of 2

Condition Forumula if Columns have Strings and if they match to preset condition

  1. #1
    Registered User
    Join Date
    11-29-2018
    Location
    Las Vegas, NV
    MS-Off Ver
    2017
    Posts
    7

    Condition Forumula if Columns have Strings and if they match to preset condition

    Hi everyone,


    I have 3 columns (J"ReOrderPoint Score", K"Inventory Status", L"Expected Shipment")

    1(J). "ReOrderPoint Score" gives values like "Increase in Order", "Decrease in Order" or "Average" determined by other columns in the sheet.
    2(K). "Inventory Status" which gives value either "Reorder" or "OnStock".
    3(L). "Expected Shipment" which gives integer value based on the number of parts that we are expecting.


    I'm trying to come up with the following :

    1. column(M) that gives "RE" if Reorder Point Score" says "Increase in Order", Inventory Status says "Reorder"and "expected Shipment" has value 0.
    2. column(N) that gives "GO"if Inventory Status is set to "Reorder" and Expected Shipment is 0.

    The goal is to narrow down the products that I need to purchase and to see if I missed anything from the list of 5000 products. If anything else is easier than what I'm thinking, I'm open to your opinion as well.

    Thanks as always,
    Roshan

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Condition Forumula if Columns have Strings and if they match to preset condition

    For the first one, try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Have a go at the second one yourself.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Moving Strings on new line if condition is met
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-06-2015, 07:25 AM
  2. [SOLVED] Lookup in columns and return if the condition is match
    By Dumy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-26-2013, 01:47 AM
  3. Match a condition and multiply columns
    By rniedzia in forum Excel General
    Replies: 2
    Last Post: 02-27-2012, 03:12 PM
  4. Replies: 2
    Last Post: 08-28-2009, 12:33 PM
  5. How to use SUMIF Forumula in this condition
    By dalipsinghbisht in forum Excel General
    Replies: 6
    Last Post: 10-14-2008, 04:07 PM
  6. Cant get a forumula to work only if a condition is met.
    By blizzard0c in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-06-2008, 06:20 PM
  7. If more than condition forumula
    By Corey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2006, 02:10 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