+ Reply to Thread
Results 1 to 3 of 3

A formula to populate one cell based on the cell range on another worksheet

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    71

    A formula to populate one cell based on the cell range on another worksheet

    I am attaching a workbook with 3 tabs and I am hoping to find help with a formula for cell B2 of worksheet "FTE Requirements".

    I would like a formula that will say if A2 (On FTE Requirements Worksheet) is equal to anything in the range of cells A2 - A 13 on worksheet Service Activity Info then cell B2 will equal the amount in column F (Total Hours REquired for Service Activity) in the cell on the same row. I would then copy the formula down to cell B7 so each cell between B2 and B7 would do the same.

    So for example on the FTE Requirements Worksheet:
    B2 would be 450
    B3 would be 170
    B4 Would be 3,150
    B7 Would be 9,558
    All based on the cell range on worksheet Service Activity Info A2:F13

    I had some help with a similar formula earlier but this one is on a different worksheet and I can't seem to make it work.

    Thanks to anyone that might be able to help me with this one. I am not even sure if it is possible. I am trying to create something that will be very simple for others that do not use excel much at all to use.
    Attached Files Attached Files
    Last edited by Squint; 01-26-2011 at 05:56 PM.

  2. #2
    Registered User
    Join Date
    09-26-2007
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: A formula to populate one cell based on the cell range on another worksheet

    Hy there mate,

    Try this:
    =INDEX('Service Activity Info'!A$2:F$5,Match(A2,'Service Activity Info'!A$2:A$5,0),6)

    Put it in cells B2:B7 on the last sheet.

    Make sure that the names of service activity are exactly the same....
    http://www.squidoo.com/best-excel-2010-book

  3. #3
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    71

    Re: A formula to populate one cell based on the cell range on another worksheet

    Thanks so much!!! This worked great!

+ 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