Index Match : To retrieve output based on two criteria.

**manish2303** · 09-02-2019, 01:53 PM

Hi i want to retrieve date as output based on 2 inputs.Excel attached.
Help is highly appreciated.

Input 1 Input 2

5S Training H1B

Output
01-01-2019

**Fluff13** · 09-02-2019, 01:59 PM

How about
=INDEX(F2:F4,MATCH(B9&"|"&C9,INDEX(B2:B4&"|"&E2:E4,0),0))

But the value in B9 is 5S (no space) whereas the values in B2:B3 are 5 S (space in between) for the above formula to work, they must be the same.

Index Match : To retrieve output based on two criteria.

LinkBack

Thread Tools

Rate This Thread

Display

Index Match : To retrieve output based on two criteria.

Re: Index Match : To retrieve output based on two criteria.

Thread Information

Users Browsing this Thread

Similar Threads

Index Match :I want to retrieve all data in one column based on criteria shown in picture.

Using index match based on two match criteria in different columns

[SOLVED] Index/Match when the Match criteria is based on a second table

VBA Code for Index/Match/Match to input into excel based on 2 criteria inside form

Need to retrieve multiple row items given two criteria (Index, Match, Row)

Index-Match based on 3 criteria

Index Match based on 2 Criteria only returning 1 match

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions