DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
Is it possible to use Index match to lookup a value based on two or more different criteria? So if it turns out that the first criteria in the index(Match( formula is not a match is it possible to then look at the second criteria as a backup per-se? So I need to look-up the ESG score in the example print-screened below and if the ticker symbol for one doesn't match then have the formula look at the ISIN number to see if it's a match and if it is bring over the ESG score. Any help would be much appreciated
[TABLE="width: 572"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] *Lookup Here[/TD]
[/TR]
[TR]
[TD]Ticker Symbol[/TD]
[TD]ISIN[/TD]
[TD="colspan: 2"]ESG Score[/TD]
[TD]Ticker Symbol[/TD]
[TD]ISIN[/TD]
[TD] ESG Score[/TD]
[/TR]
[TR]
[TD]BBBY[/TD]
[TD]US0758961009[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD]BBBY[/TD]
[TD]US0758961009[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBY[/TD]
[TD]US0865161014[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD]BBY[/TD]
[TD]US0865161014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BWA[/TD]
[TD]US0997241064[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD]BWA[/TD]
[TD]US0997241064[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CA/CTC/A[/TD]
[TD]CA1366812024[/TD]
[TD="align: right"]23[/TD]
[TD][/TD]
[TD]CTC-A[/TD]
[TD]CA1366812024[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 572"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] *Lookup Here[/TD]
[/TR]
[TR]
[TD]Ticker Symbol[/TD]
[TD]ISIN[/TD]
[TD="colspan: 2"]ESG Score[/TD]
[TD]Ticker Symbol[/TD]
[TD]ISIN[/TD]
[TD] ESG Score[/TD]
[/TR]
[TR]
[TD]BBBY[/TD]
[TD]US0758961009[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD]BBBY[/TD]
[TD]US0758961009[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBY[/TD]
[TD]US0865161014[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD]BBY[/TD]
[TD]US0865161014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BWA[/TD]
[TD]US0997241064[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD]BWA[/TD]
[TD]US0997241064[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CA/CTC/A[/TD]
[TD]CA1366812024[/TD]
[TD="align: right"]23[/TD]
[TD][/TD]
[TD]CTC-A[/TD]
[TD]CA1366812024[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]