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 to be checked with E in range 2.
Where matches it should check the respective value in B. If the respective value is between the values mentioned in G and H of range 2 it should return the value from F to C (which is result column) (but this is for case if value in G is less than the value in H).
If value in G is greter than value in H of range 2, the value in column B should be checked as; if value in B is greter than value in G and less than 60 OR value in B is less than value in H and greter than 0, it should return respective value of F in respective cell of C.
ELSE return NULL.
Range 1
A B C
X 11 Alpha
Y 30 Beta
X 30 Null
X 56 Theta
Z 1 Gamma
Y 56 Delta
X 2 Theta
E F G H
X Alpha 10 20
Y Beta 23 40
X Theta 50 8
Z Gamma 0 35
Y Delta 50 59
I have been working on in from several days but failed. Please help me urgently..
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 to be checked with E in range 2.
Where matches it should check the respective value in B. If the respective value is between the values mentioned in G and H of range 2 it should return the value from F to C (which is result column) (but this is for case if value in G is less than the value in H).
If value in G is greter than value in H of range 2, the value in column B should be checked as; if value in B is greter than value in G and less than 60 OR value in B is less than value in H and greter than 0, it should return respective value of F in respective cell of C.
ELSE return NULL.
Range 1
A B C
X 11 Alpha
Y 30 Beta
X 30 Null
X 56 Theta
Z 1 Gamma
Y 56 Delta
X 2 Theta
E F G H
X Alpha 10 20
Y Beta 23 40
X Theta 50 8
Z Gamma 0 35
Y Delta 50 59
I have been working on in from several days but failed. Please help me urgently..
