Thread
:
Enter Range
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
Enter Range
Glad to help
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"holyman" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett