Thanks thats what i needed thanks

...

only i've run into a strange problem (i probably just dont know how
that function operates)

with this formula

=IF(ISNA(MATCH(C7,Lists!B1:Lists!B4,0)),"Animal",I F(ISNA(MATCH(C7,Lists!B5:B25,0)),"Mineral",IF(ISNA (MATCH(C7,Lists!B26:B54,0)),"Vegetable","blank"))


If the entry is between B1:B4 it diplays "Mineral" and for all others
it displays "Animal" so that seems backwards and "Vegetable" doesnt
appear at all

I am using absolute references will this make a difference??


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=540255