Need help with INDEX MATCH from bottom to top

darkwizdom42

New Member
Joined
Jan 28, 2025
Messages
5
Office Version
  1. 2021
  2. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
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!
 

Attachments

  • example1.png
    example1.png
    13 KB · Views: 13
  • example2.png
    example2.png
    9.3 KB · Views: 13
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.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top