+ Reply to Thread
Results 1 to 5 of 5

IF function to include multiple cells in order to gain result

  1. #1
    Registered User
    Join Date
    04-02-2021
    Location
    Salisbury, England
    MS-Off Ver
    2019
    Posts
    4

    IF function to include multiple cells in order to gain result

    Hi,

    I have a table that I want to use IF function with to choose which other table it will collect data from and then conditional formatting to tell me if the result is sufficient. It's for parachuting weight limits, first cell that will be selected is the make of the parachute (on a separate worksheet for each manufacturer), next cell will be the size of parachute and then the result will be the maximum weight allowed on that parachute.

    Can anyone help me with how I should complete this, or is there another function that would be better suited... LOOKUP

    TIA
    Scott
    Last edited by beachy302; 04-04-2021 at 05:59 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: IF function

    It would help if you attached a sample Excel workbook. Follow the guidance given in the yellow banner at the top of the screen.

    You might also think about amending your title so that it is more descriptive of what you want to achieve.

    Pete

  3. #3
    Registered User
    Join Date
    04-02-2021
    Location
    Salisbury, England
    MS-Off Ver
    2019
    Posts
    4

    Re: IF function

    Cell I3 is the first cell I need to select from and then J3. I then need the function to correspond to the correct cell in the next worksheet. The answer here would be 252.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: IF function to include multiple cells in order to gain result

    I think it may be easier to put all your manufacturers and sizes/weights into one true Excel table. If you do this, you may be able to use this formula in L3:

    =INDEX(Table1[Max Weight],MATCH(I3&J3,Table1[Make]&Table1[Canopy Size],0))

    You can then copy this down and also copy it over to cell P3.

    See the attached. Will this work for you. If you put every Make on a separate sheet, you'll probably need to use INDIRECT to get the right sheet. How many different makes are there?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-02-2021
    Location
    Salisbury, England
    MS-Off Ver
    2019
    Posts
    4

    Re: IF function to include multiple cells in order to gain result

    Thanks Greg, I'll take a look in a bit and let you know.

+ 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. Right function, Left function, Mid function to extract values in column A
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-14-2020, 03:14 PM
  2. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  3. 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
  4. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  5. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1