Ference
Original Poster
Nov 23, 2021

How do I make QUERY without it displaying the word I'm looking up?

I have a drop-down table in Column A and in B I have a query searching another sheet for the value I put in column A. The query works but it displays the word I was searching for in column A in column B and it displays the actual value I need in column C.

Please find attached the screenshot, it's displaying "corn" twice. How do I only show the query value in column C?
Details
Sheets,Microsoft Windows,Personal use
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
--Hyde
Diamond Product Expert
Top Contributor since 12 January 2013
Nov 23, 2021
Hi Ference,
 
Try leaving the "corn" column out of the select clause.
 
If you need more help, please share a sample spreadsheet rather than a screenshot.
 
Cheers --Hyde
Community Manager Niharika S recommended this
Helpful?
All Replies
--Hyde
Diamond Product Expert
Top Contributor since 12 January 2013
Recommended Answer
Nov 23, 2021
Hi Ference,
 
Try leaving the "corn" column out of the select clause.
 
If you need more help, please share a sample spreadsheet rather than a screenshot.
 
Cheers --Hyde
Community Manager Niharika S recommended this
false
5356183237374293233
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu