+ Reply to Thread
Results 1 to 3 of 3

Need help with If formula to cover many columns and cells.

  1. #1
    Registered User
    Join Date
    03-25-2015
    Location
    Fort Madison, IA
    MS-Off Ver
    Microsoft 2010
    Posts
    2

    Need help with If formula to cover many columns and cells.

    I have created a google form for an event registration. I am now try to create an excel spreadsheet that sorts the information from one sheet to another. I don't know if my question is clear. I think I am not sure what questions to ask because I don't know what options are available. I have done something similar to this with a smaller amount of information and this is the formula I used.

    =IF('R1 - R'!$B$3=E2,'R1 - R'!$A$3, IF('R1 - R'!$B$4=E2,'R1 - R'!$A$4,IF('R1 - R'!$B$5=E2,'R1 - R'!$A$5,IF('R1 - R'!$B$6=E2,'R1 - R'!$A$6,IF('R1 - R'!$B$7=E2,'R1 - R'!$A$7,IF('R1 - R'!$B$8=E2,'R1 - R'!$A$8,IF('R1 - R'!$B$9=E2,'R1 - R'!$A$9,IF('R1 - R'!$B$10=E2,'R1 - R'!$A$10,IF('R1 - R'!$B$11=E2,'R1 - R'!$A$11,)))))))))

    Is there anything any simpler or faster?

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Need help with If formula to cover many columns and cells.

    INDEX/MATCH with a search criteria set to 0 comes to mind. However, it's hard to visualize your data. Could you upload a sample workbook?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    03-25-2015
    Location
    Fort Madison, IA
    MS-Off Ver
    Microsoft 2010
    Posts
    2

    Re: Need help with If formula to cover many columns and cells.

    The problem with that is that I have the spreadsheet created with headers but there is not much data in it yet because people have not registered. I am wanting search for a specific value in one sheet that could possibly be in multiple different columns and then return a value from another cell in the sheet where the data is found. I will attach the spreadsheet. There is one row of information on Sheet 1(Form Responses 1) I am trying to find for example if a cell says "400 - Angus" then return the value from Sheet 1(Form Responses 1), cell B2 (which would be the exhibitor's name)2015 FM FFA Cattle Show Registration (Responses).xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 06-29-2013, 03:56 PM
  2. [SOLVED] Cover sheet formula
    By jklangenberg in forum Excel General
    Replies: 9
    Last Post: 07-14-2011, 06:17 PM
  3. Copying a function to cover many cells
    By Helio in forum Excel General
    Replies: 5
    Last Post: 12-14-2007, 05:58 PM
  4. [SOLVED] how to cover the formula
    By Lawrence in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2005, 01:25 PM
  5. [SOLVED] Extending sub to cover other target cells
    By Max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-06-2005, 06:35 PM

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