NBVC helped me a great deal in creating the below formula,
This allows certain columns from a workbook to be 'v looked up' without the user having to vlookup or filter so long as the condition (if true) is met. It works a treat however when the user selects another date in the future it also shows up if the condition is true.
I only want the data to show up once, when the date selected is the same as the date the data was entered on. (Its a stock control system - see attached summary stock re-order sheet).
Has anyone an idea how I can add another condition to the above formula to achieve this?