Thread: LookUp Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LostNFound LostNFound is offline
external usenet poster
 
Posts: 11
Default LookUp Problem

I need to look at a single cell and it will contain a value from 1-1000, I
want to return different letters based on the cell value. Using ranges for
different letters

Example - 1-100 will return an A, 101-150 will return a B, etc. all the way
to 1000 in increments of 50.

The column C will contain the a number between 1 and 1000 and I want to
return a letter based on the example above in a different column.