+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Need help with downtime form

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    lincon, ne
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need help with downtime form

    Ok I'm not very bright with Excel so here is my quandary...

    In this spreadsheet I am trying to capture all of my equipment downtime at my plant. Some of the formulas have been very easy, however capturing the top three downtimes for the line has been much more difficult.

    in B9 i have
    Please Login or Register  to view this content.
    in B10 i have
    Please Login or Register  to view this content.
    in B11 i have
    Please Login or Register  to view this content.
    So then I want to put the description for each of the top three downtimes in the cells that correspond in column C, this is what I have so far...
    Please Login or Register  to view this content.
    How do I get it to follow the same pattern down the columns? Say my highest number was actually in G11 and it should say "steak transfer conveyor"?

    Anyways, I appreciate the help in advance...

    testing downtimes.xlsx

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Need help with downtime form

    in C9 copy and paste and drag it down
    =IFERROR(VLOOKUP(B9,$I$2:$N$16,3,0),VLOOKUP(B9,$G$2:$N$16,5,0))

+ 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