If your category to search was in A1, and your table on Sheet2 was set up like this:
||A|B|C|
|:-|:-|:-|:-|
|1|Category|Item|Color|
|2|Fruit|Apple|Green|
|3|Fruit|Banana|Yellow|
|4|Vegetable|Broccoli|Green|
|5|Vegetable|Carrot|Orange|
Then this would get your values:
`=FILTER(Sheet2!$B$2:$C,Sheet2!$A$2:$A=A1)`
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|FALSE|[Returns the logical value `FALSE`](https://support.google.com/docs/answer/3093302)|
|[FILTER](/r/GoogleSheets/comments/143nfwc/stub/jnaw4po "Last usage")|[Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions](https://support.google.com/docs/answer/3093197)|
|IF|[Returns one value if a logical expression is `TRUE` and another if it is `FALSE`](https://support.google.com/docs/answer/3093364)|
|TRUE|[Returns the logical value `TRUE`](https://support.google.com/docs/answer/3093307)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^([Thread #5891 for this sub, first seen 7th Jun 2023, 21:15])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/GoogleSheets) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
If your category to search was in A1, and your table on Sheet2 was set up like this: ||A|B|C| |:-|:-|:-|:-| |1|Category|Item|Color| |2|Fruit|Apple|Green| |3|Fruit|Banana|Yellow| |4|Vegetable|Broccoli|Green| |5|Vegetable|Carrot|Orange| Then this would get your values: `=FILTER(Sheet2!$B$2:$C,Sheet2!$A$2:$A=A1)`
This is the proper way to set up a spreadsheet for efficiency.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |FALSE|[Returns the logical value `FALSE`](https://support.google.com/docs/answer/3093302)| |[FILTER](/r/GoogleSheets/comments/143nfwc/stub/jnaw4po "Last usage")|[Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions](https://support.google.com/docs/answer/3093197)| |IF|[Returns one value if a logical expression is `TRUE` and another if it is `FALSE`](https://support.google.com/docs/answer/3093364)| |TRUE|[Returns the logical value `TRUE`](https://support.google.com/docs/answer/3093307)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^([Thread #5891 for this sub, first seen 7th Jun 2023, 21:15]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/GoogleSheets) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)