I am using excel 2003 and I am trying to make a formula shorter since 2003 only allows 7 if statements I need to add 2 more.
Here is the formula
=IF($G$137={"Minion","Minions"},VLOOKUP($H$133,$F$155:$P$159,$H$134+1,FALSE),IF($G$137={"Brute","Brutes"},VLOOKUP($H$133,$F$167:$P$171,$H$134+1,FALSE),IF($G$137={"Soldier","Soldiers"},VLOOKUP($H$133,$F$179:$P$183,$H$134+1,FALSE),IF($G$137={"Archer","Archers"},VLOOKUP($H$133,$F$179:$P$183,$H$134+1,FALSE),IF($G$137={"Skirmisher","Skirmishers"},VLOOKUP($H$133,$F$191:$P$195,$H$134+1,FALSE),IF($G$137={"Boss","Bosses"},VLOOKUP($H$133,$F$203:$P$207,$H$134+1,FALSE),IF($G$137={"Unique Monster","Unique Monsters"},VLOOKUP($H$133,$F$215:$P$219,$H$134+1,FALSE)," ")))))))
Thanks for any help given.
Here is the formula
=IF($G$137={"Minion","Minions"},VLOOKUP($H$133,$F$155:$P$159,$H$134+1,FALSE),IF($G$137={"Brute","Brutes"},VLOOKUP($H$133,$F$167:$P$171,$H$134+1,FALSE),IF($G$137={"Soldier","Soldiers"},VLOOKUP($H$133,$F$179:$P$183,$H$134+1,FALSE),IF($G$137={"Archer","Archers"},VLOOKUP($H$133,$F$179:$P$183,$H$134+1,FALSE),IF($G$137={"Skirmisher","Skirmishers"},VLOOKUP($H$133,$F$191:$P$195,$H$134+1,FALSE),IF($G$137={"Boss","Bosses"},VLOOKUP($H$133,$F$203:$P$207,$H$134+1,FALSE),IF($G$137={"Unique Monster","Unique Monsters"},VLOOKUP($H$133,$F$215:$P$219,$H$134+1,FALSE)," ")))))))
Thanks for any help given.