Enter Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...
31 - 60 52
91 - 180 118
etc

Can this be done at all?
 
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"})
 
Back
Top