need help with function

[eltyar]

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

+-------------------------------------------------------------------
|Filename: ex.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=931
+-------------------------------------------------------------------

 

[Claus Busch]

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.

 

[eltyar]

Hi,

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

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.

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 no
found

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

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),MATCH(B3,$I$2:$M$2,0)),0)
for earlier versions try:
If(Iserror(YourFormula);0;YourFormula)


Regards
Claus B.

 

[eltyar]

Hi,

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

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


Regards
Claus B.

thanks boss :

+-------------------------------------------------------------------
+-------------------------------------------------------------------