need help with function
 

hello All,

please i need help to finish the below

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

thanks a lot in advance.

need help with function
 

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

you r my man BRO,
thanks alot it's working like charm.

just one more thing i need to put "0" if any value in the function not found.

need help with function
 

Hi,

Am Thu, 21 Nov 2013 08:46:35 +0000 schrieb eltyar:

just one more thing i need to put "0" if any value in the function not
found.

if you use xl2007 or later:
=IFERROR(INDEX($I$1:$M$6,MATCH(A3,$I$1:$I$6,0),MAT CH(B3,$I$2:$M$2,0)),0)
for earlier versions try:
If(Iserror(YourFormula);0;YourFormula)


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

thanks boss :)