+ Reply to Thread
Results 1 to 3 of 3

Index formula problem excel 2007

  1. #1
    Registered User
    Join Date
    07-27-2014
    Location
    Southampton UK
    MS-Off Ver
    2007
    Posts
    13

    Index formula problem excel 2007

    Can anyone help sort out this problem

    Import C details deliveries to be made that day - sent in from another department.

    Workbook "Monday Run" details the drivers run sheet (602 RS) and his load (602OL). If the site ID appears in Import C then a "C" is put in 602 RS column D, and the site ID in 602 OL B28:B40. A vlookup then puts the details from Import C into the respective column in 602OL (D28 to O40).

    The problem occurs when a site has two or more orders for delivery that day - in this case both sites C062 and C070 have two deliveries each.

    Is there any way to amend the formula to pick up the second delivery from Import C for these sites??

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Index formula problem excel 2007

    To amend which formula? Which cell? What are the expected results in that cell?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    Southampton UK
    MS-Off Ver
    2007
    Posts
    13

    Re: Index formula problem excel 2007

    Hi Jerry

    Ive uploaded a sheet showing what I'm hoping to achieve.

    Apologies for being a thicket and not being able to explain it better.
    Attached Files Attached Files

+ 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. [SOLVED] Excel 2007 : Removing the #n/a from this index match formula
    By Icehockey44 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2015, 12:47 PM
  2. Index formula problem Excel 2007
    By kbaz555 in forum Excel General
    Replies: 2
    Last Post: 09-21-2014, 12:37 PM
  3. Problem with Vlookup-- not finding proper answer
    By Rino007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2013, 01:51 AM
  4. [SOLVED] Excel 2007 : Sumif, Index, match formula
    By Bebe22 in forum Excel General
    Replies: 4
    Last Post: 07-27-2012, 10:27 AM
  5. Excel 2007 : excel 2007 formula bar problem
    By mettam in forum Excel General
    Replies: 46
    Last Post: 07-21-2010, 05:21 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