Text LookUp More Than One Condition

Topic

New Reply

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

Reply | Quote

Replies

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

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))

Reply | Quote

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.

Reply | Quote

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

Reply | Quote