GOOGLE SHEETS: Help with my Query formula?

[BadFish523]

=IF(A2="Work Instructions",QUERY(Data!A2:N,<wbr>"select D where E='"&C2&"' and F='"&E2&"'"),IF(A2="Standard Work",QUERY(Data!A2:N,"select D where H='"&C2&"' and I='"&E2&"')")))

I'm trying to build a query that can be manipulated a little bit. What I want is for it to query (sheet'Data') columns e and f when box A2 says Work Instructions but I want it to query columns (sheet 'Data') h and i when box A2 says Standard Work. Anybody know how to do this?

Edit: Forgot to add the first part of the query works fine. Only when I change A2 to Standard Work does it not work.

 

[Joe4]

Re: Help with my Query formula?

I am not aware of any QUERY function in Excel.
Is it part of an Add-In or is it a User Defined Function?

 

[BadFish523]

Re: Help with my Query formula?

I am not aware of any QUERY function in Excel.
Is it part of an Add-In or is it a User Defined Function?

Oh man, my bad. I forgot to post I'm using Google Sheets. I just figured out my issue though. I had an extra parenthesis in my formula. Should look like this (minus the red parenthesis) and it will work:
=IF(A2="Work Instructions",QUERY(Data!A2:N,<wbr>"select D where E='"&C2&"' and F='"&E2&"'"),IF(A2="Standard Work",QUERY(Data!A2:N,"select D where H='"&C2&"' and I='"&E2&"')")))

 

[Joe4]

Re: Help with my Query formula?

OK. Glad you figured it out.

I moved your question to the "General Excel & Other Discussion Questions" forum, as that is the best place to post Google Sheet questions.
I also added it to the title of the post (you will want to be sure to mention somewhere that it is for "Google Sheets").