need help with function

E

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
+-------------------------------------------------------------------
 
C

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.
 
E

eltyar

Claus said:
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
C

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.
 
E

eltyar

Claus said:
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 :

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top