If match index returns value X, then use match index to return new value

**Fish55** · 04-07-2020, 11:14 AM

I am using Index match to return a value but if a certain value is return then is it possible to do another index match.

To better explain I am have attached a example. in the example I am match index the corridor but if the value comes back as 'PFW' then I would like it to then lookup the next column in the data set.

Thank you.

**AliGW** · 04-07-2020, 11:21 AM

Try this:

=IF(INDEX('Exampe Data'!B:B,MATCH(A2,'Exampe Data'!A:A,0))="PFW",INDEX('Exampe Data'!C:C,MATCH(A2,'Exampe Data'!A:A,0)),INDEX('Exampe Data'!B:B,MATCH(A2,'Exampe Data'!A:A,0)))

**Fish55** · 04-07-2020, 11:48 AM

Thanks AliGW!

**AliGW** · 04-07-2020, 11:58 AM

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

If match index returns value X, then use match index to return new value

LinkBack

Thread Tools

Rate This Thread

Display

If match index returns value X, then use match index to return new value

Re: If match index returns value X, then use match index to return new value

Re: If match index returns value X, then use match index to return new value

Re: If match index returns value X, then use match index to return new value

Thread Information

Users Browsing this Thread

Similar Threads

Index Match based on multiple Match criteria that returns each subsequent occurence.

How to use INDEX, MATCH, SEARCH to return an exact match for entire cell contents

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

[SOLVED] Index+Match+Match doesnt returns right values

[SOLVED] IF date value returned from Index/Match is blank, return prior cell that returns a value

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

[SOLVED] I need to Return Multiple Matches While Index(Match) only returns the First one.

Bookmarks

Bookmarks

Posting Permissions