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 therefo 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.


--
CdFMarshall
------------------------------------------------------------------------
CdFMarshall's Profile: http://www.excelforum.com/member.php...o&userid=32085
View this thread: http://www.excelforum.com/showthread...hreadid=518392