Populating list based on criteria

[pauldaddyadams]

Hi,

I require some help/direction in regards to a formula.

I have a unique list on the sheet “Daily” column W which is the reference point for columns X and Y.

On the “Manual Journal Daily” sheet cell J7 it contains a drop down list giving the user the option to select the date.

What I would like in the yellow highlighted rows is when there is a date in J7 for it only to return data for this date. If it is blank then return all entries.

Can anyone help please?

I have uploaded an example.

[Glenn Kennedy]

Try this array formula. These are Array Formulas. They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

[pauldaddyadams]

Gelnn - this did it! Thank you so much!

I think you helped me with a similar problem recently.

Ill mark this solved

[Glenn Kennedy]

Thanks for the Reputation that you have added. It's much appreciated... And yes; we have "met" before on the EF. For now, if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.