Index and match from 2 rows

[chaiyya345]

Hi All,
Hope you all are doing great!

I understood how Index & Match works but it only returns the 1st value. What I wish to achieve is to index the temperature. Since the name is having duplicates, I cant just match from the name but need to have another match which is time too. How to achieve this?

Any help is greatly appreciated.

Please find attachment

Thank-You very much

[AliGW]

See if this works for you:

=LOOKUP(2,1/((temperature!$C$2:$C$10=index_match!A2)*(temperature!$A$2:$A$10=index_match!$B$2:$B$10)),temperature!$B$2:$B$10)

[chaiyya345]

Hi Ali,

No, it didn't work. I attached your formula from index_match!D2:210

Thank-You very much

[AliGW]

Explain "didn't work". Showing me what I have suggested doesn't tell me what isn't working for you.

I have no idea what you are aiming for!

[AliGW]

Is this it?

=LOOKUP(2,1/((temperature!$C$2:$C$10=index_match!A2)*(temperature!$A$2:$A$10=index_match!B2)),temperature!$B$2:$B$10)

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[chaiyya345]

Hi Ali,

you are great! the 2nd suggestion works!
will mark this thread to solved & issued you with reputation.

Thank-You very much.