Hi,
I need to check multiple conditions from range 1 in range 2 and based on TRUE conditions return the specified data.
Suppose I have two ranges (Range 1 comprises of A,B & C columns for processing & Range 2 Housing comprises of E F G & H columns)
A has values X,Y,Z and so on which need...