Google Sheets QUERY How can I do the same in Excel?

I will take a look for you

2 things while I am looking...

1. wow those colors are hard on the eyes
2. Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2003, but your file indicates at least 2007

hmm OK what exactly are you trying to do there?

Im thinking taht something like this should work...
=INDEX(RawData!$A:$A,SMALL(IF(RawData!$I$2:$I$1000<>"declined",ROW(RawData!$A$2:$A$1000)),ROWS($A$1:A1)))

This is an ARRAY formula...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 your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

But I am having a hard time making it work becasue of the UK/US date forma difference, plus you have no July data in your sample anyway

I did try changing to week 10, but the data format is throwing me off. It will be quicker for you to test, than for me to adjust things to US date format.

Also, I left out teh date check in my formula...
=INDEX(RawData!$A:$A,SMALL(IF((RawData!$I$2:$I$1000<>"declined")*(RawData!$P$2:$P$1000>=Week01!$B$2),ROW(RawData!$A$2:$A$1000)),ROWS($A$1:A1)))
still CSE entered

Doesn't this just import a single cell?, I need to import cells from the A,E,F,H,J,L,O columns if the row meets the not 'declined' and date match criteria. It should import all rows that meet the criteria

Sorry really tired can't seem to find the words to explain what I am trying to do. Thanks again for your time

yes, it does pull into a single cell. once we have that, we can progress to the others.

I dont use google sheets, so I dont know how the QUERY works, but generally, excel formulas only work on/in 1 cell, and only affect the cell they reside it

Sorry really tired can't seem to find the words to explain what I am trying to do.

Then dont try to explain, show some sample expected answers?

1. make sure your headings match exactly (eg you have Postcode on RawData, but Post Code on Week01)
2. in Raw sheet, change the P formula to =IFERROR(DATEVALUE(D2),"") to remove the errors from row 201 onwards
3. Try this ARRAY formula, copied down and across...
=IFERROR(INDEX(RawData!$A:$P,SMALL(IF((RawData!$P$2:$P$1000>=Week01!$B$2)*(RawData!$J$2:$J$1000<>"Declined"),ROW(RawData!$A$2:$A$1000)),ROWS($A$1:A1)),MATCH(B$3,RawData!$A$1:$P$1,0)),"")
...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 your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

All the other dates look to be before the date in week01 B2, so they are being excluded.