Newbie Help - IF, VLOOKUP, not sure which Formula to use

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

Thanks Hans, really appreciate this - life saver !!

Now, for me to try and understand this formula and how you've done this so I can use it in the future.

I also only provided you a cut down version of my spreadsheet, so I'll have to play around with it to see if I can get it to work - which is fine because that'll allow me to learn.

Thanks again.

Cheers,

WB

Thanks Ali,
I'm still trying to work it out at my end as the spreadsheet I gave was a smaller version of what I need.
I've never seen a formula like this before, like I said, I'm a beginner with it all.
If I can get it to work, I'll mark as resolved. I've also added Reputation as a thanks.
Just found this website/forum from a quick Google Search, looks great.
Cheers,
WB

Ok, so I'm struggling and just get #VALUE when I try and adjust the formula.
Comments:
- I've tried changing the Column Numbers to match my spreadsheet (The Board Approval Date is the 10th Column, not 3rd)
- I've changed 'Col_Num 2' in the formula to '10' and I've referenced my own Worksheet (not the 'Data Sheet' as per the example) and it's still showing '#VALUE'

I'm sure I'm doing something else wrong, but Yes Ali, if you can explain in more detail that would be great.

Thank you.

Hi Hans / Ali,
Sorry, I’ve got a 2 week old and 2 year old at home and have only just been able to get back to emails after they both kicked off at home.
I’m not in front of the PC, but I saw my error was in the Range Data just before I had to deal with the family, so I think I know where the problem is.
I’ll jump onto this in the morning and report back.
Thanks again for your help, great forum and appreciate how prompt you’ve both been (shame my young kids don’t seem to appreciate it .
Cheers,
WB

Great, thanks Ali.
Whilst this is more of a 'nice to have' I would like the Data that is populated by this Formula to keep the Headings used in my Table.
For example, using the spreadsheet you uploaded, Store 4 should display under a Heading of 'Open' (refenced from Cell A4 in the 'Data Sheet'). Store 14 would have a Heading of 'Under Construction' and Stores 20-22 would have a Heading of 'Board Approved'.
Whilst the current formula gives me what I need, it doesn't show what 'stage' the Stores are at, and given this data will continually change, I can't hard code these in.
Is it possible to include the Headers some how??

I've used the formula you provided to create multiple Summary Tables in my Worksheet, it's been fantastic and I can't thank you both enough so far.
I also didn't know you could join formulas like you have !! Sure beats my standard =SUM =COUNTA and =COUNTIF formulas that I use !!

Cheers,
WB

Thanks Ali - see attached, example added to your spreadsheet.

Cheers,
WB
ATTACH]848786[/ATTACH]

Great, thanks Ali, will check it out later tonight - thanks again.

Hi Ali / Hans,
If I want to add another 'Filter' to the Formula, how do I do this:
For example, I want the Formular to look for "FY24" as per the Formula you provided:
=LET(t,CHOOSECOLS(FILTER('Data Sheet'!$A$6:$D$99,'Data Sheet'!$E$6:$E$99="FY24"),1,3,4),IF(t="","",t))
but I also want it to look for "Approved" as well.
So it'll only show the Stores that have "FY24" in one column and "Approved" in another column.
Where and how do I add this extra Filter in?
Thanks again.
Cheers,
WB

Thanks Ali,
I'll give that a go.

What does the '*' do in a Formula? I would have assumed it's a Multiply Function and would have caused an error?
I'm assuming I can also add a 3rd or 4th Filter/Muliplier in should I need to? (I don't at this stage, but just trying to learn how I can structure this formula in the future)?

I haven't given up on Post #18. I spent 15 mins on it the other night, couldn't get it to work and got side tracked with the young family. Then this issue has come up and I need to resolve it first. We get to #18 again shortly.

Friday afternoon here in Australia, sending you a virtual glass of wine (bottle!) for your help, really appreciate it.

Cheers,
WB

Great, I wondered what the difference would be if I used a +.

I've tried to give you another Rep, but is says I need to spread it around before giving you another Rep (hard when this is the only post I've made).

Cheers