From Reports to a Dashboard - How?

[Richdewtan]

Ok, I have figured out the Countif, and basic vlookup concept. However, what I can't figure out is how to search the text data in one worksheet (Part numbers) and populate a shortlist of those part numbers based on their status (Open/close) into another worksheet.

It seems to me, that vlookup will only allow this if I stay in the same worksheet. Is there a formula that will address this?

 

[Toadstool]

Hi Richdewtan,

VLOOKUP will work across worksheets, so will INDEX and MATCH to fin matching part numbers. If you're trying to list a subset then the SMALL option of AGGREGATE may be the way to go.

It would be best if you could provide a sample of your data and expected results using XL2BB.

 

[Richdewtan]

Hi Richdewtan,

VLOOKUP will work across worksheets, so will INDEX and MATCH to fin matching part numbers. If you're trying to list a subset then the SMALL option of AGGREGATE may be the way to go.

It would be best if you could provide a sample of your data and expected results using XL2BB.

Thanks for the input - Though I have not tried your solution, I found that a simple Pivot Table does the job for me.

However, my countif formula that is pulling from another worksheet does not update on its own returning a #VALUE error unless I open the report the info is found in.