+ Reply to Thread
Results 1 to 2 of 2

Adding additional cells to cells with formulas.

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Seattle
    MS-Off Ver
    Excel -MS Office 365 Subscription
    Posts
    44

    Adding additional cells to cells with formulas.

    I have attached an example file as to what i'm trying to acheive as i'm not sure i can explain it thoroughly.

    Under the "Contract Numbers" sheet in Cell E7 i have a formula in place already but i need to add an additional cell from the "Consultants" sheet. In the "Consultants" sheet i have multiple bidders in and whoever is the lowest i need to add that cell (in this case, Cell L4) to Cell E7 in the "Contract Numbers" sheet. Respectively i'll need to do this for the cell below L5 to be added to Cell E8 in the "Contract Numbers" sheet.

    Hope that made sense.

    Thank you in advance for your help.

    Phil
    Attached Files Attached Files
    Last edited by pjfoster; 02-21-2012 at 08:39 PM.

  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,464

    Re: Adding additional cells to cells with formulas.

    Not sure. Maybe:

    =IF(ISNA(OFFSET(Consultants!F3,MATCH(MIN(Consultants!$O4:$O13),Consultants!$O4:$O13,FALSE),0)),"",OFFSET(Consultants!F3,MATCH(MIN(Consultants!$O4:$O13),Consultants!$O4:$O13,FALSE),0)+OFFSET(Consultants!G3,MATCH(MIN(Consultants!$O4:$O13),Consultants!$O4:$O13,FALSE),0))

    Regards, TMS
    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)

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