|
Enter Range
I have a list of data in Column B, and I need a formula in column A that
returns either dependant on what the cell value is in column B. Needs to return on of the following '<31', '31 - 60', 61 - 90', '91 - 180', '180' e.g Column A Coulmn B 31 - 60 45 180 189 31 - 60 52 91 - 180 118 etc Can this be done at all? |
Enter Range
You can use nested IF functions or LOOKUP .
Look in the help index for LOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "holyman" wrote in message ... I have a list of data in Column B, and I need a formula in column A that returns either dependant on what the cell value is in column B. Needs to return on of the following '<31', '31 - 60', 61 - 90', '91 - 180', '180' e.g Column A Coulmn B 31 - 60 45 180 189 31 - 60 52 91 - 180 118 etc Can this be done at all? |
Enter Range
Many thanks for pointing me in right direction. Now got what I need (well it
returns the correct values!! =LOOKUP(I2,{0,31,61,91,181,1000},{"<31","31 - 60","61 - 90","91 - 180","180"}) "Don Guillett" wrote: You can use nested IF functions or LOOKUP . Look in the help index for LOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "holyman" wrote in message ... I have a list of data in Column B, and I need a formula in column A that returns either dependant on what the cell value is in column B. Needs to return on of the following '<31', '31 - 60', 61 - 90', '91 - 180', '180' e.g Column A Coulmn B 31 - 60 45 180 189 31 - 60 52 91 - 180 118 etc Can this be done at all? |
| All times are GMT +1. The time now is 08:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com