+ Reply to Thread
Results 1 to 9 of 9

If Function help

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    NY
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    If Function help

    Screen shot 2012-08-08 at 5.16.06 PM.pngScreen shot 2012-08-08 at 5.15.13 PM.png

    Here's my dilemma:
    I am working off of two separate sheets in a workbook (see the screen shots). I want to write a formula that will put the "Table Host" Name found in sheet 2 (column c) in column G (sheet1) IF column "A" on sheet2 has a particular value.

    The Values in sheet 2 column A range from 1-5. So, for example if there is a "1" in sheet 2 column A I want the Table host name "Keenan Miller" to appear in John Doe's Column G.

    Not only this but I would like excel to find all the "1's" in column A and place their corresponding table host name in a separate blank cell for John Doe in column G and all the 2's in Column G for Jane Doe and so on...
    Attached Files Attached Files
    Last edited by kdawgmil; 08-08-2012 at 06:55 PM. Reason: adding workbook

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If Function help

    for a start off, it would serve you better to upload an actual workbook, rather than a picture, seeing as how you have the workbook anyway. not every1 can veiw png's, myself included, and few are inclined to retype all of your data, even if they can.

    having said that, without seeing your data, it sounds like for you'r 1st part a vlookup may work...
    =VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match
    perhaps an if() statement would help with your 2nd part, but again, lets take a look at your data
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    NY
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    Re: If Function help

    workbook added

  4. #4
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: If Function help

    Hi kdawgmil - your instruction are a little confusing because sheet 1 is not really sheet 1 in your spreadsheet. But I think I understand what you want.

    Try this in G1.
    =VLOOKUP($A$2,'Table Hosts'!$B$2:$P$293,2,0)

    Note: also its not really a good idea to merge cells when building a spreadsheet. Its makes create formulas a nightmare.

  5. #5
    Registered User
    Join Date
    08-08-2012
    Location
    NY
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    Re: If Function help

    I really appreciate it. And sorry for the confusion. I'll try playing around with the formula and see how it goes. Oh and thanks for the note on the merged tables. I'll keep that in mind.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If Function help

    thx.

    not sure why you have 5 rows for each "Number" on sheet 2, but this formula will reference your data from sheet1 and add the table host for you...
    =VLOOKUP(A2,'Table Hosts'!$B$2:$C$261,2,FALSE)

    not sure i understand your requirement for the 2nd part of your question. if you just want to show the name repeated for the other 4 rows in G, then a simple =G2, copied down (apart from the initial vlookup cell) would work.

    let me know please

  7. #7
    Registered User
    Join Date
    08-08-2012
    Location
    NY
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    Re: If Function help

    The 5 rows are potentially all the people the committee person could be supervising. this is also the reason for the second part of my questions. For example: on the table host tab/sheet Keenan miller, Trinity Church and Jim Pestke could all be labeled with a "1" in column A. This would mean that (now looking at the banquet timeline tab/sheet) John Doe would be supervising Keenan, trinity and Jim. I would like a formula to match all this up and put the names Keenan, trinity and jim in Column G of the Banquet timeline page...one on each line. So that means 3 of the 5 lines for John Doe in Column G would be taken up.

    Hope that makes sense. Sorry, I'm new at this and =vlookup is also new

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If Function help

    thats ok, no problem did you try the vlookup i suggested yet tho, to see if it At least starts giving you what you want?

  9. #9
    Registered User
    Join Date
    08-08-2012
    Location
    NY
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    Re: If Function help

    Thanks for your help. The Vlookup was not what I was looking for. I restructured my worksheet and now using a mail merge with word to work out my problem. More steps but I got what I wanted. I think this problem it too hard to explain clearly via forums.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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