Results 1 to 4 of 4

If name = one in the list then x - y; Help me please!

Threaded View

damagas If name = one in the list... 06-13-2013, 05:12 AM
Fotis1991 Re: If name = one in the list... 06-13-2013, 05:22 AM
:) Sixthsense :) Re: If name = one in the list... 06-13-2013, 05:24 AM
damagas Re: If name = one in the list... 06-13-2013, 06:54 AM
  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Ireland Dublin
    MS-Off Ver
    Excel 2003
    Posts
    14

    If name = one in the list then x - y; Help me please!

    Hi guys,

    I'm doing this Process/Stock sheet and I'm trying to find a way to subtract what ever was used from stocks. For example: 10 boxes of type 'A' were used - stock is 20. 30 boxes of type 'B' were used - stock is 40. Sounds simple ,but the problem is there is so many types that I had to make a drop down list and from there I wanted the values to come up automatically, but I don't know how to get a field to recognize witch value has to be taken. Please Help Me!!

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1