index and matching 2 colums and 1 rows

[shahdelsol]

I am trying to use index/match when 2 matches found in columns, perfrom row match. I have tried these 2 functions but they are not working.
For your infromation , A2 and A:A column content is date and same date could be found in several cells.

=INDEX(LIST!I:M,MATCH(1,($A$2=LIST!A:A)*(D3=LIST!B:B)*(L2=LIST!I2:M2),0))

INDEX(LIST!I:M,MATCH($A$2=LIST!A:A,0),MATCH(D3,LIST!B:B,0),MATCH($L$2,LIST!$I$2:$M$2,0))

Can anyone help what I am doing wrong here?

 

[Alex Blakenburg]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Assuming you have MS365 and that you want the figure from a specific column and using your current formula, I would expect it to look more like this:

=INDEX(LIST!I:M,
               MATCH(1,($A$2=LIST!A:A)*(D3=LIST!B:B),0),
               MATCH(L2,LIST!I2:M2,0))

 

[shahdelsol]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Assuming you have MS365 and that you want the figure from a specific column and using your current formula, I would expect it to look more like this:

=INDEX(LIST!I:M,
               MATCH(1,($A$2=LIST!A:A)*(D3=LIST!B:B),0),
               MATCH(L2,LIST!I2:M2,0)
[/QUOTE]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Assuming you have MS365 and that you want the figure from a specific column and using your current formula, I would expect it to look more like this:

=INDEX(LIST!I:M,
               MATCH(1,($A$2=LIST!A:A)*(D3=LIST!B:B),0),
               MATCH(L2,LIST!I2:M2,0))

Thank you so much. This worked!

 

[Alex Blakenburg]

You're welcome. Thanks for letting me know and also for updating your profile