Hi guys!

I have the following section of a current 'Sheet' i am working on.

Forum Formula.jpg


In Cell 'X8', how do i search within the Range W1:W8 and if any of the Cells contains anything, return this value in Cell 'X8'?



Any advice greatly appreciated

Cheers!