+ Reply to Thread
Results 1 to 3 of 3

Formula to insert number in column if name is chosen on another sheet

  1. #1
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Formula to insert number in column if name is chosen on another sheet

    Example.xlsxTrying to get C28:C35 to AG28:AG35 to populate with the number 1 when the same name is chosen on another sheet. On the "Daily" sheet if K2 is the same as the "Costs" sheet B28 then the number 1 should be populated in "Costs" C28 etc. the actual workbook has 31 "Daily" sheets.
    I have it working except if the "Costs" sheet is blank then cell B28 it populates a 1 in C28...I know there has to be some work around for this but can't seem to figure it out.
    I can be a macro or a cell formula, it doesn't matter to me.
    Thanks for your help.
    Last edited by groundin; 02-08-2013 at 01:51 PM. Reason: wrong excel file attached

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Formula to insert number in column if name is chosen on another sheet

    try this
    =IF(Costs!$B30="","",IF(Daily!$K4=Costs!$B30,1,""))

  3. #3
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Re: Formula to insert number in column if name is chosen on another sheet

    So simple! Thanks!

+ 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