# Using IF with more than 7 limitation

1. ## Using IF with more than 7 limitation

I need to use the "IF" formula on a worksheet with 15 variables. There is a limit of 7 that can be used at once, does anyone know a way around this?

Thank you for any help I can get!

2. ## Re: using formula "IF"

Several ways around it... can you give an example of what you are trying to do?

3. ## Re: Using IF with more than 7 limitation

I included my excel file. I need the second sheet to read what number is typed (aisle) return the number of cases from sheet1 ( ex. b4=3 then returns c7 from sheet 1) but I need that for all of the aisles (column b of sheet1)

4. ## Re: Using IF with more than 7 limitation

So you want the sum of all cases where Aisle number is 3...

Put a 3 in B4 and then enter this formula in B5:

=SUMIF(Sheet1!\$B\$5:\$B\$37,B\$4,Sheet1!\$C\$7:\$C\$37)

which you can copy across the row, aisles in row 3 will be looked up and summed.

5. ## Re: Using IF with more than 7 limitation

I don't need the sum just the number of cases of the aisle # that is typed, If I would type in 3 into B4 on sheet 2 I would get back 10(cell c7 sheet1) into B5 of sheet 2. If I would type in 4 then I would get back the contents from C9 of sheet 1.
Unfortunately I have to leave right now I will return tomorrow morning. Thank you for the help.

6. ## Re: Using IF with more than 7 limitation

Then:

=VLOOKUP(B\$4,Sheet1!\$B\$7:\$C\$37,2,0)

This returns the value in C which matches the first occurance of the value in B that, in turn, matches B4 from Sheet2

7. ## Re: Using IF with more than 7 limitation

Originally Posted by NBVC
Then:

=VLOOKUP(B\$4,Sheet1!\$B\$7:\$C\$37,2,0)

This returns the value in C which matches the first occurance of the value in B that, in turn, matches B4 from Sheet2
This worked perfectly. I've never used LOOKUP before, now I can see some other uses for it. Thank you very much!

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

#### 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