Respected Sir/Madam,
I have to check a particular cell value lies between two column values and copy a corresponding a cell value accordingly. E.g. Please refer the image i have attached here with.
I have to check the value in column K, if it lies between B and C, I have to copy the in Column E to Column L. In short, For the numbers 1 to 10 in column K, I have to copy the number in column E4(i.e 7) and for the numbers 11 to 15 in column K, I have to copy the number in column E5(i.e. 6) and so on. Can any body help me with a formula to achieve this? Thanks in advance.
I have to check a particular cell value lies between two column values and copy a corresponding a cell value accordingly. E.g. Please refer the image i have attached here with.
I have to check the value in column K, if it lies between B and C, I have to copy the in Column E to Column L. In short, For the numbers 1 to 10 in column K, I have to copy the number in column E4(i.e 7) and for the numbers 11 to 15 in column K, I have to copy the number in column E5(i.e. 6) and so on. Can any body help me with a formula to achieve this? Thanks in advance.