Search in spreadsheet (CTRL+F)

General
1

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.

2

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.