Help with index match with multiple rows criteria

**parreich** · 07-09-2015, 02:58 PM

Hi all,

I need help with the Index match formula. I need a formula to fill the cells in yellow with the numbers included in the DATA column

Thank you very much

**JohnTopley** · 07-09-2015, 03:03 PM

Is there only one figure per year per item?

**reagan.kha** · 07-09-2015, 03:11 PM

Hello please see attached for the solution.

The formula must be inputted as an array formula. You can do this by hitting CTRL + SHIFT + ENTER.

**micope21** · 07-10-2015, 02:52 AM

Hi

No array formula

F9

Formula:

Please Login or Register  to view this content.

Enter then Copy cross.

Help with index match with multiple rows criteria

LinkBack

Thread Tools

Rate This Thread

Display

Help with index match with multiple rows criteria

Re: Help with index match with multiple rows criteria

Re: Help with index match with multiple rows criteria

Re: Help with index match with multiple rows criteria

Thread Information

Users Browsing this Thread

Similar Threads

Formula needed for partial string match as part of index match with multiple criteria

Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns

VLookup or Index/match searching rows instead of columns or multiple criteria

[SOLVED] INDEX+MATCH with multiple criteria across both rows and columns

[SOLVED] Index and Match Multiple Header (Rows) Criteria

Bookmarks

Bookmarks

Posting Permissions