Formula Indice /Corresp

Hello -

I'm not 100% sure I understand what you want, but I think this is close. On the GRANEL tab, I added the following formula to cell D5:

=IFERROR(IF(INDEX(INDIRECT("'"&$A5&". "&$B5&"'!$A$5:$E$40"),COUNT(INDIRECT("'"&$A5&". "&$B5&"'!$A$5:$A$40")),5)=D$3,INDEX(INDIRECT("'"&$A5&". "&$B5&"'!$A$5:$E$40"),COUNT(INDIRECT("'"&$A5&". "&$B5&"'!$A$5:$A$40")),4),0),"")

This formula is not as complicated as it looks.

Starting with the Green Text: This formula uses INDIRECT to create a text cell range address from your Location Desicriptions on GRANEL tab, Cell A5 and B5. I did this so I can copy the formula down and it will automatically redirect the forumla to each tab in your workbook. I then use INDEX to return the number based on COUNT() which counts the number of cells with numbers in them in the date column of (in this case) Sub. 1A A5:A40. It finds the row of the last entry, and passes that to INDEX.

The RED text is exactly the same as the Green text EXCEPT it checks to see if the product type is of the last entry on Tab Sub. 1 A and compares it to the product type in Cell D3. If it's the same product type, then show the result of the Green text. If it's NOT the same product type, show 0. This is how I get the products to line up correctly in your table on GRANEL.

Finally, since many of your tabs are missing (like Tab Sub. 4 A, Sub. 5 A, and so on, I enclosed the whole thing in an IFERROR staement to just show "" is the tab sheet is missing.

Attached is your spreadsheet with the above formulas copied to the other cells.

I hope this is what you were looking for.

Great! Glad I was able to help.