Lookup & Match question

[Learn-more]

I need to match value1 in Column A and value2 in Column B then get the text
from Column C. I know how to use filterin the worksheet to do it, but this
case I need to get the text in the sheet as someone key in 2 values then
display the corresponding text message.

Any expert can help me? Thanks.

 

[T. Valko]

Try this:

E1 = value1
F1 = value2

This array formula** :

=INDEX(C1:C100,MATCH(1,(A1:A100=E1)*(B1:B100=F1),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Learn-more]

I got it work. Thanks.

Try this:

E1 = value1
F1 = value2

This array formula** :

=INDEX(C1:C100,MATCH(1,(A1:A100=E1)*(B1:B100=F1),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

I got it work. Thanks.