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?