Hi,

Am Wed, 20 Nov 2013 14:04:02 +0000 schrieb eltyar:

need function to look in "name" and "type" columns and fill the "price"
column automatically as information data inside the sheet attached.

In C3 try:
=INDEX($I$1:$M$6,MATCH(A3,$I$1:$I$6,0),MATCH(B3,$I $2:$M$2,0))
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2