Microsoft Teams Blog articles

INDEX MATCH with VLOOKUP

This is my first time posting here, as I hit a roadblock that I'm sure is simple enough.  I am using the following formula, but the source data ('FY26 Income Statement Data'!$A$4:$A$2158) has several rows with the same criteria on 'Cash Flow'!$A7.  I think I need to include a VLOOKUP formula but I don't know how to do this.  Any help will be appreciated. =INDEX('FY26 Income Statement Data'!$A$4:$AB$2158,MATCH('Cash Flow'!$A7,'FY26 Income Statement Data'!$A$4:$A$2158,0),MATCH('Cash Flow'!C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0))
favicon
techcommunity.microsoft.com
techcommunity.microsoft.com