Lookup with a stop if cell value equals a specific text?

[MnJeeper]

Hi New Here and stuck on an excel problem hoping someone can help with.

In short I am trying to link an excel sheet for a user to pull data from a number of vendor reports that consolidates a number of tabs and sheets into one that the user can print off Monthly. I have it all done but stuck in one piece. In 3 spots on the reports there are changing fields in between others that only show data in the respective fields so the number of fields is always changing and when a value is present the 2 categories can have fields with the same name so lookup, index and match may pull from the wrong category at times.

IE if one Month there is no field listed for Processed in 3 Day on Rec. but it's there for Del, then it pulls the Del # into the Rec group. I want to search only from Receive Process to Deliver Process and if the cell equals "Deliver Process" then stop. I am also not familiar with VBA and hoping formulas will solve for this. Then when the fields are present, pull the 3 data fields to the right of it. Any tips or help would be great!

Thanks!


Month 1
Receive Process Volume %of Total Average
Total Rec Processed:
Processed in 1 Day
Processed in 2 Day
Processed in 3 Day
Processed in 4 Day
Processed in 5 Day
Processed in 6 Day
Processed in 7 Day
Processed in 8 Day
Processed in 9 Day
Processed in 10 Day
Deliver Process Volume %of Total Average
Total Del Processed:
Processed in 1 Day
Processed in 2 Day
Processed in 3 Day
Processed in 4 Day
Processed in 5 Day
Processed in 6 Day
Processed in 7 Day
Processed in 8 Day
Processed in 9 Day
Processed in 10 Day

[AliGW]

Welcome to the forum!

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[MnJeeper]

Hi Thanks, I just attached a sample sheet. The cells starting on A28 would link to A1:D25 but will vary with the changing months. The Months to the right are samples how the data changes. Thanks!