More then 7 IF functions?

Hi all,

I am new here and found this forum because, as most persons here I guess, I need some help in Excel.
I have been building a worksheet for my job information but get stuck.

What is the problem? I'll try and explain:
I am building an overview of ingredients of petfood. It should finally result in a sheet in which you can fill in a value and the sheet says it is ok or not.

In one sheet I have therefore lined out a couple of sorts petfoods (junior, adult, and so on) with the values of the ingredients it would contain in an ideal situation (for instance, vitamines of the standard food with a minimum, maximum and mean value). I hope this part is clear, please ask if it's not.

In the second sheet, the values which I find in a batch are filled in. It shows as following:
date-batchcode-productcode-productname-and then the values I have found for the ingredients followed by a correct / incorrect
It contains multiple functions.
The first function is the function that allows you to only insert the productcode and excel will automatically fill in the productname. I created this function for it:

=IF(C4="010";"product A";IF(C4="015";"product B";IF(C4="020";"product C";IF(C4="030";"product D";IF(C4="040";"product E";IF(C4="050";"product F";IF(C4="060";"product G";IF(C4="070";"product H";"INCORRECT"))))))))

Uptill the moment of product G it works fine, but then I get product H, which is the 8th product and therefore excel can not put it in one line anymore (as excel can only include 7 IF functions) so it automatically gives an INCORRECT.

First question is therefore: Is there a way to change this so I can include more then 7 products in the function line?


Then, I'll continue, If this is possible: How can I recreate this to an automatic function which automatically takes the values of sheet 1 for that specific product into account?
So when I insert a date, batchcode, a productcode (at this moment excel should automatically insert the productname) and then insert a value which I found for that batch, excel should automatically compare this to that specific value in sheet 1...

I hope you know what I mean and furthermore I of course hope you can help me because I almost gave up on this already....

Thanks!

CdFMarshall
I need a worksheet which contains in one sheet stats that can be considered normal.


edit: mmm, I know see I maybe did not post this in the right subforum. Sorry if so...