Need help on this formula explained by chandoo

[MohanBabu1023]

Hi team,

http://chandoo.org/wp/2014/10/28/multi-condition-vlookup/

Note:- Above link show's that formula

When iam searching for formula in chandoo i got the formula which I needed but it's not working,Can anyone help on this.


Regards
Mohan.

 

[bobhc]

You give no information to your problem so that members can help you.
Why is it not working? There could be any number of reasons.
Why can't you receive help on the scant information you have given, probably because members are not mind readers.

Upload the formula that you have and the data you are working with.

.

 

[MohanBabu1023]

Hi bobhc,

Sorry for not attaching the file,now it is attached.

 

[MohanBabu1023]

Sorry bobhc,

I founded the mistake,thanks for your reponse.

Thank you

 

[bosco_yip]

Change this

=VLOOKUP(A12&B12,CHOOSE({1,2},A1:A6,B1:B6,C1:C6),2,0)

into this array formula:

=VLOOKUP(A12&B12,CHOOSE({1,2},A1:A6&B1:B6,C1:C6),2,0)

Confirm enter pressing with SHIFT+CTRL+ENTER 3 keys

Regards
Bosco

 

[MohanBabu1023]

Hi Bosco,

Thanks for support.

Can we able to follow same concept for countif also,if yes then share me a sample.

Regards
mohan

 

[bosco_yip]

Hi Bosco,

Thanks for support.

Can we able to follow same concept for countif also,if yes then share me a sample.

Regards
mohan

C12 :

=COUNTIFS(A2:A7,A12,B2:B7,B12)

Regards

 

[MohanBabu1023]

Hi Bosco,

Thank U very much for your support

Regards
mohan