Hi all,
I hope this hasn't been answered elsewhere but I haven't found anything.
I have three columns of data. For each value in column C, I want to determine if it falls between two values in the same row in column A and B
e.g. if C1 = 30, A20=25 and B20=40, I want to return "TRUE" in D1.
I tried =VLOOKUP(C1, A:B, 2, TRUE) but the problem is that if C is NOT between two values on the same row in columns A and B, it just returns the nearest value from one of the columns.
All I want is to differentiate values in column C that fall DO between any pair of values in A and B from values that DON'T.
Any suggestions hugely appreciated! Thanks in advance.
I hope this hasn't been answered elsewhere but I haven't found anything.
I have three columns of data. For each value in column C, I want to determine if it falls between two values in the same row in column A and B
e.g. if C1 = 30, A20=25 and B20=40, I want to return "TRUE" in D1.
I tried =VLOOKUP(C1, A:B, 2, TRUE) but the problem is that if C is NOT between two values on the same row in columns A and B, it just returns the nearest value from one of the columns.
All I want is to differentiate values in column C that fall DO between any pair of values in A and B from values that DON'T.
Any suggestions hugely appreciated! Thanks in advance.