Multiple criteria
 

Hi, i have this code:
=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)

This code retrieve numbers. I need a code, just like that, a code for
multiple criteria, that retrieve text.
Can this be done?
Thanks!

Multiple criteria
 

Note by wanting a text returned, I'm assuming you will only have 1 match of
your criteria. If text is in column C

=INDEX(Sheet1!$C:$C,SUMPRODUCT(--(A1=Sheet1!$A$1:$A$100),--(B1=Sheet1!$B$1:$B$100),--(ROW(Sheet1!$C$1:$C$100))))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"puiuluipui" wrote:

Hi, i have this code:
=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)

This code retrieve numbers. I need a code, just like that, a code for
multiple criteria, that retrieve text.
Can this be done?
Thanks!

Multiple criteria
 

It's working great.
Thanks allot!

"Luke M" a scris:

Note by wanting a text returned, I'm assuming you will only have 1 match of
your criteria. If text is in column C

=INDEX(Sheet1!$C:$C,SUMPRODUCT(--(A1=Sheet1!$A$1:$A$100),--(B1=Sheet1!$B$1:$B$100),--(ROW(Sheet1!$C$1:$C$100))))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"puiuluipui" wrote:

Hi, i have this code:
=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)

This code retrieve numbers. I need a code, just like that, a code for
multiple criteria, that retrieve text.
Can this be done?
Thanks!

Multiple criteria
 

For a two way lookup check these sites. If you need more help, please come
back

Two-way lookup
http://j-walk.com/ss/excel/usertips/tip020.htm

Thorough solution:
http://www.cpearson.com/excel/TablesAndLookups.aspx

Simple solution:
http://www.contextures.com/xlFunctio...ml#IndexMatch2

BTW: SUMPRODUCT is generally used not to return a singe value but to add
values according to multiple criteria
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"puiuluipui" wrote in message
...
Hi, i have this code:
=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)

This code retrieve numbers. I need a code, just like that, a code for
multiple criteria, that retrieve text.
Can this be done?
Thanks!