List all values found within a range.

Hi all,

I have a problem with finding the value in column B that is found within a range eg: <=1 & >=5 and return the corresponding values found in column A.

Please kindly refer to the attached sample for reference. Any help will be appreciated.

Thanks in advance.


Best Regards,

Eric