Pull Information From Sheet to Sheet Based on Descending values and cell value

art1884

New Member
Joined
May 19, 2018
Messages
7
Good Afternoon,

Need your assistance once more time, I am working in a tracker and need assistance with pulling information from one sheet to another. I need the information in the green sheet (Sheet 2) below to be transferred to a purple sheet Dashboard (Sheet 1). the information needs to be pulled based on DAYS DUE column descending from highest to lowest FIRST and if the status is IN PROCESS ONLY with the corresponding information there after.
1652828142387.png


the information has to fill the table below in the Dashboard (Sheet 1), final product in the below table.

1652827645832.png


This is the final product with the information being pulled and rearranged to descend from the asstet down the longest and status in process only. I copied and pasted the information but I would like it to be auto populated.
1652828103489.png


Please let me know if anyone needs more information to make this work. I tried VLOOKUP, index, match but I can't figure it out. Thank you in advance.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,908
Messages
6,175,307
Members
452,633
Latest member
DougMo

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