+ Reply to Thread
Results 1 to 5 of 5

Help with IF function

  1. 07-20-2017, 04:41 PM #1
    plantexploration
    plantexploration is offline
    Registered User
    Join Date
    07-20-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    5

    Help with IF function

    Hi all,

    I am looking for code advice to get my workbook how I wish.

    About my workbook:
    I have a two page workbook. 1st sheet is titled "Sign Ups"
    Second is "Sponsors"

    Sign ups contains the following info
    A1 Company Name
    B1 Address
    C1 City
    D1 State
    E1 Zipcode
    F1 Sponsor (YES or blank for no)

    I am wanting to find a code that will take data from Sign Ups (1st sheet) and transfer to Sponsors (second sheet) if I type "YES" in the F1 Sponsor cell. I want not only F1 cell to transfer to the second sheet Sponsor but I want the entire row to transfer so I have all sponsor information on my second sheet Sponsors including Company name, address, city, state, zip, YES

    So I have the code:
    =IF(FIND("Y",'Sign Ups'!F1)<>0,'Sign Ups'!F1,"")
    Which pulls the YES over but I need it to be a range to pull A1:F1 over if YES is typed in F1 cell.

    I hope this is clear. Please help. Thank you!
    Attached Files Attached Files
    Last edited by plantexploration; 07-20-2017 at 05:03 PM.
    Reply With QuoteRegister To Reply
  2. 07-20-2017, 04:49 PM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Help with IF function

    Hi, welcome to Excel Forum! A small sample workbook (NOT a picture) would really help us to solve your problem quickly and accurately.
    Remove any sensitive or extraneous info, just show us what cells contain your data and formulae, what results you want, and where you want them.

    To attach a workbook:
    Click Edit Post (or just start a new reply.)
    Click Go Advanced
    Scroll down to Manage Attachments and click.
    Now just Browse for your file, then click Upload. Simple!
    Reply With QuoteRegister To Reply
  3. 07-20-2017, 05:05 PM #3
    plantexploration
    plantexploration is offline
    Registered User
    Join Date
    07-20-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Help with IF function

    I have updated my post with a sample workbook, thank you for the direction. As you can see in the sample work book, In Sign Ups the Row 2 is filled out and they are a sponsor indicated in F2. I wish to have the entire row of information transfer to 'Sponsors' sheet if F2 is selected "Y"

    With the header row 1, the best code I have come up with is:

    =IF(FIND("Y",'Sign Ups'!F2)<>0,'Sign Ups'!F2,"")

    But I need to include the f2 cell to include the entire range from A2:F2

    That way it will preload the information to the Sponsors tab and save me a lot of time. Then in the sponsor's tab I can then just enter the specifics for that sponsorship. Thank you.
    Reply With QuoteRegister To Reply
  4. 07-20-2017, 06:07 PM #4
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Help with IF function

    Hi plantexploration, welcome to the forum! Paste this ARRAY FORMULA* in Sponsors!A2 and copy down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Then paste this in B2 and copy across to F2 and down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    *Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
    When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
    Attached Files Attached Files
    Last edited by leelnich; 07-20-2017 at 06:41 PM.
    Reply With QuoteRegister To Reply
  5. 07-20-2017, 06:43 PM #5
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Help with IF function

    Post #4 Attached File and VLOOKUP formula updated to show blanks correctly.
    Thanks for the rep! If complete, please go to Thread Tools up top and mark your thread as SOLVED. Thanks!-Lee
    Last edited by leelnich; 07-20-2017 at 06:47 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Usage of standard functions into custom function (or user defined function)
    By tusharb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2016, 12:43 AM
  2. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  3. Excel 2010 VBA Sheets Copy function works, but then jumps to the beginning of a function
    By mycroft in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  4. VBA function similiar to Vlookup function to extract data from multiple worksheets into 1
    By msiddiq1208 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  5. Excel NORM.DIST function gives results greater than 1 with probability mass function. How
    By jano_rajmond in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  6. Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference
    By giallofever in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  7. [SOLVED] Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1