Google sheet forumla translate to Excel

[posfog]

Hi All,
I have the following formula that i used in google sheets but now putting my data on excel but need the following formula to work in excel or something that does the same

Could anyone help at all please?

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

=query('SHEET1'!A3:L, "Select G, A, C, D, H, I, J, L where B = '"&UPPER(B2)&"' and F = 'OPEN' order by G desc limit 5", 0)

Regards
P​