Board index MS EXCEL

index match array function-returning only first match, need la

index match array function-returning only first match, need la

Post by ZGFkZHlsb2 » Fri, 29 Dec 2006 11:13:00


My apologies, that should be.....

=INDEX(MIDDATE!$G$2:$G$21624,MATCH(1,(MAX((MIDDATE!$I$2:$I$21624=R12)*(MIDDATE!$J$2:$J$21624<S12)*MIDDATE!$J$2:$J$21624)=MIDDATE!$J$2:$J$21624)*(MIDDATE!$I$2:$I$21624=R12),0))
 
 
 
Top

index match array function-returning only first match, need la

Post by SnVsaWUgT2 » Sat, 30 Dec 2006 09:50:00

Thank you very much, it worked beautifully. It took me a while to figure out
why, but I get it now. You just made my data analysis much more possible.

 
 
 
Top

1. Lookup Formula: Return 1st match, then 2nd match, then 3rd match

2. Index and Match with more than one Match

3. How do I display more than one match in a Index/Match formula?

4. Match as well as does not match array function

5. Return index in 1 of 2 arrays if match is found

6. INDEX & MATCH find first column value in an array?

7. What does the Search 1-D array vi return with more than one match?

8. Help me to first row matching First date and last row matching last row

9. Need help on index and match function

10. I think I need a match, vlookup, or index function?

11. Index and match functions help needed.

12. Need help with function using INDEX and MATCH.

13. =INDEX(C3:N22,MATCH(G26,B3:B22),MATCH(H26,C2:N2))

14. index,match,match on un-sorted data

15. How would I make this match, index, match work?

All times are UTC
Board index