Need help with INDEX MATCH from bottom to top

[darkwizdom42]

Hello all!

Needed a little help to see if this was possible.

So I have a formula setup to pull values from a worksheet/report I paste into the Master worksheet everyday. I only really use the data on the last few lines of the report and since it varies and changes everyday, I usually just copy and paste that bottom section into my master workbook and it pulls fine. However, I want to ask if there was a way to be able to just create a formula that pulls this data without having to only copy and paste that bottom section. Just copy the whole thing and have the formula pull the value.

I included a few screenshots to show what I mean. Note that the yellow highlight indicates that it can change everyday (Categories and Names) and the pink highlights are the values I'm looking to pull (the total "solved" for each category).

Hope it makes sense. Let me know if you require any further clarification.

The current formula I use is:

=IFERROR(INDEX($A:$H,MATCH("SOLVED:",$A:$A,0),MATCH("ENTRY",$A$3:$H$3,0)),0)

Thanks in advance!

 

[Jeffrey Mahoney]

Hello DarkWizdom,

In my opinion, using a formula still forces you to copy something. Let's say there is a formula on the Master sheet, how would you lock that down? If you leave the formula, the next day the data will change on the Report sheet and you wouldn't have saved the previous day unless you copy the formula down and value the current day.

I can't tell by the small pictures, but there must be many "Solved" rows in each report? Maybe a formula could shorten the steps to copy each solved row by. I would use the filter function to grab those on a summary sheet, and then copy from there.

Or use VBA to copy all the Solved rows data to the Master.

 

[darkwizdom42]

Thanks for the reply! That makes sense.

Much appreciated!