Index Match

**UNNI NAIR** · 11-13-2017, 05:01 AM

Good Day, Friends.

Attaching a sample file for reference. in this file
IF(AND - Formula works exactly, But I need
another better formula.

Thanks
Unni.

**shukla.ankur281190** · 11-13-2017, 05:08 AM

Try

Formula:

Please Login or Register  to view this content.

**UNNI NAIR** · 11-13-2017, 05:29 AM

Dear Mr. Ankur, your formula works good. Thanks

**shukla.ankur281190** · 11-13-2017, 05:30 AM

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

Index Match

LinkBack

Thread Tools

Rate This Thread

Display

Index Match

Re: Index Match

Re: Index Match

Re: Index Match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?

[SOLVED] Index / Match - match 3 input values and return the results from the index

[SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays

INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

Problems with multi-criteria Index/Match. LOOKUP works. Index/Match, SUMPRODUCT,ARRAY fail

Index, match, dynamic and connected without sorting helper column non-adjacent index match

[SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings

Bookmarks

Bookmarks

Posting Permissions