Hello!

I have an array of 8 columns and 50+ rows. Each row has one value that falls somewhere in the 8 columns. The rest of the columns are empty. I need a function to search the row for the value and then display that value in one cell.

Capture.PNG

Please let me know if you can help.

Thank you,
Jesse