+ Reply to Thread
Results 1 to 2 of 2

Help needed asap please!

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    1

    Help needed asap please!

    This is my spread sheet.

    -- A -- B -- C -- D -- E
    1 H1500 2 X1500 2
    2 T448601 1 N0421 1
    3 H1500 2 T448601 1
    4 M1224 1 S789003 1

    What I need is:

    Cell Column “E” should return values as follows:

    If “A1” = “x1500”, return value of B1. (ie, wherever “A” = x1500, E will show the same as B. If that condition is not met, E will show a value of zero.)

    However…it is not just “x1500” I am looking for, I have 11 different codes I need it to search.

    In plain English:

    If “A” equals either “x1500” or “x1001” or “x2525” etc etc, then E should show the value of B.

    Heres the real scenario, might make it a bit easier…”X1500” represnts one of our products…I need to count how many of those products appear, but I need to count all 11 “X” products. I can easily create a formula that counts how many times an “x” code appears, but it doesn’t take into account the column next to it (quantity).

    To throw another perm in…I need this formula to search not just A1, but C1, E1 etc so I have 6 different columns searched for any “x” codes!!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Please take the time first to read our forum rules...

    Then amend the title to be more appropriate for the actual question.

    Thank you.

    P.S. Also, please indicate exactly what you want to achieve. You have changed the scenario with each sentence.
    Last edited by NBVC; 06-25-2008 at 08:29 AM.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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