Hello everyone.
I am having some trouble figuring out how to pull multiple results from multiple tables using INDEX MATCH.
I have 12 tables (one for each month), and I'm trying to make an annual table that pulls specific data (based on a single criterion) from the 12 monthly tables.
After Googling some similar problems, I've managed to get a working formula to pull data from two tables, but I can't figure out how to pull data from all 12 tables.
The formula I have so far is:
{=IFERROR(IFERROR(INDEX($A$2:$A$6,SMALL(IF(ISNUMBER(MATCH($B$2:$B$6,$B$15,0)),MATCH(ROW($B$2:$B$6),ROW($B$2:$B$6)),""),ROWS($A$1:A1))),INDEX($D$2:$D$6,SMALL(IF(ISNUMBER(MATCH($E$2:$E$6,$B$15,0)),MATCH(ROW($E$2:$E$6),ROW($E$2:$E$6)),""),ROWS($A$1:A1)-COUNTIF($B$2:$B$6,$B$15)))),"")}
I have attached a sample file of what I'm working with.
Any help is greatly appreciated; thanks!
Edit:
I have cross-posted on the following websites:
https://www.mrexcel.com/board/thread...ables.1195297/
https://chandoo.org/forum/threads/in...-tables.47538/
https://www.excelguru.ca/forums/show...fferent-Tables
Bookmarks