Search a range and return a value from a non-blank cell

[69liz]

Hi,

I have a range of 5 cells - only one of them shows a value at any one time because they are dependent on an input in another part of the sheet.

I now need to record the value elsewhere in the sheet. How can I search the range of 5 and return the value that is showing?

All of the 5 contain an IF statement but only 1 will ever show a value at a time.

Thanks,

Liz

 

[Aladin Akyurek]

Thanks Aladin.
I came back to the thread because the original solution stopped working - would only work for the 2nd, 4th and 5th values in the range.
Your solution seems to work just fine!
Thanks

You are welcome.