# Thread: Text LookUp More Than One Condition

1. Hi there,

I need someone's help, for a formula in result column in Table 1 as attached file, to pick up text in result column in Table 2.

Thanks and regards

Indra[attachment=87916:Text Lookup More Than One Condition.xls]

2. Originally Posted by Indra Kusuma
Hi there,

I need someone's help, for a formula in result column in Table 1 as attached file, to pick up text in result column in Table 2.

Thanks and regards

Indra[attachment=87916:Text Lookup More Than One Condition.xls]
try this array formula in C3 (confirm with Ctrl + Shift + Enter)

=INDEX(\$C\$10:\$C\$15,MATCH(1,(\$A\$10:\$A\$15=A3)*(\$B\$10 :\$B\$15=B3),0))

3. You could also use:
=LOOKUP(2,1/((\$A\$10:\$A\$15=A3)*(\$B\$10:\$B\$15=B3)),\$C\$10:\$C\$15)
which does not require array-entering.

4. Thanks for respond guys. I will use Rory's one, because difficult for me to control array stay in formula.

Once more, people around me will think I am genius! while I keep tell everybodies about this lounge, but seems no one follows, : )

Rory, hope I can get back to this thread sometime if my brain to slow to understand the logic

regards

Indra

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•