# Search in spreadsheet (CTRL+F)

**URL:** <https://discourse.nodered.org/t/search-in-spreadsheet-ctrl-f/18635>\
**Category:** General\
**Created:** [30 November 2019 14:05 UTC](https://discourse.nodered.org/t/search-in-spreadsheet-ctrl-f/18635 "2019-11-30T14:05:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![debouttek](https://avatars.discourse-cdn.com/v4/letter/d/848f3c/32.png) [@debouttek](https://discourse.nodered.org/u/debouttek)\
**Post date:** [30 November 2019 14:05 UTC](https://discourse.nodered.org/t/search-in-spreadsheet-ctrl-f/18635/1 "2019-11-30T14:05:08Z")

</div>

My msg.payload output gives me a number from 0 to 40.

I have a spreadsheet with 2 columns and 40 rows.  
Column A contains data from 0 to 40 and column B contains information that I need.

Is it possible to search in the spreadsheet in column A and display the result from column B in node red?

Like when you do CTRL+F in a spreadsheet.

Or is there a other way? Its only 40 rows.

I can use the change function and make 40 lines.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [30 November 2019 14:28 UTC](https://discourse.nodered.org/t/search-in-spreadsheet-ctrl-f/18635/2 "2019-11-30T14:28:07Z")

</div>

output to Dashboard using the ui table extension then search in the browser.

Or simply put in a change node with a JSONata query or use a function node to filter the output and dump to the debug panel.