View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nickfunsw nickfunsw is offline
external usenet poster
 
Posts: 2
Default how do i assign a range of numbers to a cell in excel

how do i assign a range of numbers to a single cell, i have a vlookup
function which looks up a table where the cells in the first column are
labled 2 to 5, 5 to 7, 7t o 9 and 9 to 12, but this is just text and excel
doesnt recognise it, how do i get these cells to actually represent these
ranges