Computers & Electronics

Excel Formula Help - IF Formula

  • Last Updated:
  • May 10th, 2011 4:34 pm
Tags:
None
Sr. Member
Apr 23, 2009
901 posts
87 upvotes

Excel Formula Help - IF Formula

Hey guys, hopefully somebody can help me out with an Excel formula.

I need to do multiple If statements within a single formula. So the formula has to check if, for example, cell J2=4, then cell L2=Ontario, if not, then if cell J2=9, then cell L2=Quebec, etc... It needs to check for about 50 different numbers, so J2 has numbers from 1-50.
5 replies
Deal Addict
User avatar
Jun 22, 2004
3048 posts
944 upvotes
Adams06 wrote: Hey guys, hopefully somebody can help me out with an Excel formula.

I need to do multiple If statements within a single formula. So the formula has to check if, for example, cell J2=4, then cell L2=Ontario, if not, then if cell J2=9, then cell L2=Quebec, etc... It needs to check for about 50 different numbers, so J2 has numbers from 1-50.
Create a table (in different worksheet?) where column A is 1-50 and column B is the corresponding name (e.g A2=2, B2=Ontario). Than just use a VLookUp function from column L.
Deal Fanatic
Aug 25, 2005
5485 posts
2762 upvotes
knapper wrote: Create a table (in different worksheet?) where column A is 1-50 and column B is the corresponding name (e.g A2=2, B2=Ontario). Than just use a VLookUp function from column L.

This sounds like the perfect solution...
Deal Fanatic
User avatar
Apr 4, 2009
7698 posts
794 upvotes
North York
WontonTiger wrote: I think that depends on the version of excel.

I think I remember doing some formulas with over 10 nested if statements.
+1. This was how it was done in the past. It was really hard to debug these nest if statements 5 deep! (But it does work.)

In OP's case VLookup will work.

Top