+ Reply to Thread
Results 1 to 4 of 4

A formula for finding a text in a range and the corresponding cell data to sheet 2

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Twin Falls idaho
    MS-Off Ver
    Excel 2003
    Posts
    2

    A formula for finding a text in a range and the corresponding cell data to sheet 2

    OK here goes I'm not a professional at this but I'm not dumb with excel, however i can't for the life of me figure this one out or how to make it work the way i need...So i am Making a schedule and i am putting together a schedule at a glance. Anyway on sheet one i have a daily planner with the times in col A and and the days of the week in row 3 i want to be able, on sheet 2 find a "Name" on say Monday from Sheet 1 and then paste the corresponding time from Col A on sheet1 and put it where i need it on sheet 2. i have tried =sumif(c1:c20, "NAME", a1:a20) but all i get is Number like .3333333333 or .534324433. PLEASE HELP!!!!

    Sheet1

    A B C
    1 8:00 Sara
    2 8:30 Kelley
    3 9:00 Brittney

    Sheet2
    A B C
    1
    2
    3 Sara 8:00 (find Sara on sheet1 and put the time she works from Sheet1)


    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: A formula for finding a text in a range and the corresponding cell data to sheet 2

    Little bit confusing. Post a copy of your workbook so we can see exactly what you want. Put the expected results where you want them and highlight then with a comment or note for clarity.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-18-2013
    Location
    Twin Falls idaho
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: A formula for finding a text in a range and the corresponding cell data to sheet 2

    Ok let me see if i can simplify this, on sheet 1 in column A3-A59 i have Times stamps, in column B3-B59 i have names, now on sheet 2 A2 i need to find a formula that will find a "name" on sheet 1 Column B get the Time stamp that is in Column A in the corresponding Row and put it on sheet 2 A2, i would think that a simple =if(sheet1.b3:b59="name";Sheet1.a3:a59;"") would work however it will only put the Time stamp in the corresponding column and row on sheet 2 Not just Sheet 2 A2. any suggestions?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: A formula for finding a text in a range and the corresponding cell data to sheet 2

    Try this formula instead:

    =VLOOKUP(A2,CHOOSE({1,2},Sheet1!B3:59,Sheet1!A3:A59),2,FALSE)

+ 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