Find solution
What are some of the specific criteria for Formula One?

Excel 2007 help with formula?

  • I am trying to set up a formula to look at cell A2 and then If a one of the criteria is met it will fill the answer in B2 I am using several different nested IF formulas but unfortunately I can only enter 7 but need a lot more, is there way this limit can be increased or is there another way to achieve the same result, here’s the formula =IF(A2="Test","Manager",IF(A2="Test1","M…

  • Answer:

    Use the VLOOKUP function instead of the IF. Make a table with the possibilities in the left column and the "results" in the right column. Your table would look like this: M-----------N Test Manager, Test1 Manager1 Test2 Manager2 Test3 Manager3 Test4 Manager4 Test5 Manager5 Test6 Manager6 Test7 Manager7 I put the table in M1:N8 and used this formula in B2 =IF(A2="","",VLOOKUP (A2,$M$1:$N$8,2,0))

Dave at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

If you post the rest of the formula, I might be able to help. Alternatively, carry out the first 7 nested IFs and have them write the answer to C2, then pick it up and use it for the next 7, putting it in D2, until you get the answer and pop it into B2. EDIT... If what you posted is the actual series of statements, then try this... =IF(LEFT(A2,4)= "test", CONCATENATE("Manager", RIGHT(A2,1)),"blank") That will work for single digit values. Edit Part 2 (can you tell I'm bored) Using this formula: =IF(LEFT(A2,4)= "test", CONCATENATE("Manager", MID(A2,5,3)),"blank") Will allow for Test/Manager values up to 999. (again, thanks to Yahoo, as you discovered earlier, I've had to split the code over a couple of lines.)

Stewart Johnston

Had the same problem myself until a work colleague told me to use sheet 2 for my data ie column a had the result then column b had what it would equate to. Don't quote me on the formula but it should look something like this (not exact as I'm on my phone and can quite remember) =IF(A2='sheet2'A1:A20,'sheet2'B1:B20)

James

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.