Hi All,
I only have a beginner level knowledge of Formulas and can't seem to find the right formula to perform the function I need - can you please advise which formula I should use.
Attached is an example Workbook, there's 2 Worksheets ('Data Sheet' and 'Summary Sheet').
I need the formula to populate data in the 'Summary Sheet'. The data is referenced from the 'Data Sheet'.
In the 'Summary Sheet' I need to insert the 'Store Name' from Column A in the 'Data Sheet' IF the 'FY Date' in Column E = "FY24".
If the formula doesn't detect "FY24" in Column E (for the whole Worksheet or Range Selection) then I don't want anything returned (I have 100+ Rows, and only want the 'FY24' Stores to be returned)
The formula also needs to disregard 'Blank' Rows as there will be a few with the formatting of this Worksheet.

Once this is done, I then need a Formula to do the following:
IF a 'Store Name' is returned in the 'Summary Sheet' from the new Formula above, then insert that Stores 'Board Approved Date' from Column B and the 'Construction Start Date' from Column D' of the 'Data Sheet'.

I'm sure there's a way for Excel to do this, but it's above my current Talent Levels.

Thanks all, appreciate you taking the time to read and respond.

Cheers,

WB
Formula Help Example.xlsx