Bob,

Thanks for your response (have been ill a couple of days so couldnt
respons sooner) but I don't get it (still have to convert it to the
dutch language ;) )...

You say, use a combination of IF, AND and VLOOKUP...:

=IF(AND(VLOOKUP(C2,Sheet1!A1:C10,2,False)=E2,VLOO
KUP(C2,Sheet1!A1:C10,3,False)<=E2),"In range","Out of range")

But I don't get it.
What you say in my reading is: If the value in E2 (I suppose thats the
value I fill in?) is both equal/smaller then and equal/bigger then the
values in sheet 1-A1 till C10 column 2 and 3 (I suppose with this you
mean bigger/equal then minimum and smaller/equal then maximum value)
excel should mention "in range".
Ok, if thats what you mean, then I get that. But how do you make excell
look in the correct row that is combined with that product?

For example, if I fill in productcode 010 in sheet 2, excel now
mentions automatically the productname in the next cell. Ok, nice, but
in sheet 1 all products are mentioned below eachother with all
different minimum and maximum values for, for eaxample, vitamin B.
So if column A of sheet 2 is the batchcode I fill in, column B would be
the productcode (010 and so on) and column C would be the productname
(which excel automatically pops up). Column D would then be the value
of the ingredient (take vitamin B) which I found in the product and
which I fill in. In column E would then be mentioned if this value is
in range/out of range. But for this excel should look at the values
specifically for that product (010 for instance) and not for all
minimum and maximum values. Because the value could be ok for product C
(030) but out of range of product A (010) and then it should give an out
of range...

You understand what I mean? (it is hard to explain)

Thanks again for any response!

Marshall


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