Prev: Taking data from a row moving it to another row and sorting it.
Next: Grouping Years in a Pivot table
From: T. Valko on 26 Jan 2010 21:02
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Reno" <Reno(a)discussions.microsoft.com> wrote in message
news:CDF26348-88D1-439D-A4DA-30FA0DA9A836(a)microsoft.com...
> That worked, thanks!
>
> "T. Valko" wrote:
>
>> Works OK for me. Make sure calculation is set to automatic:
>>
>> In Excel 2007:
>>
>> Formulas tab>Calculation>Calculation Options>Automatic
>>
>> All other versions of Excel:
>>
>> Tools>Options>Calculation tab>Automatic>OK
>>
>> You also might want to remove the quotes from around the numbers:
>>
>> =LOOKUP(A1,{0,1000,2000,3000,4000,5000,6000},{7,6,5,4,3,2,1})
>>
>> Quoting numbers makes them TEXT.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Reno" <Reno(a)discussions.microsoft.com> wrote in message
>> news:695D744B-E607-43CA-92B9-0BC8216F0A17(a)microsoft.com...
>> > have weekly store gross profit report(s) and want to assign a letter
>> > based
>> > on
>> > a range of $0, 1000,2000,3000,4000,5000, 6000 which would return
>> > 7,6,5,4,3,2,1 respectively...have tried
>> > =lookup(A1,{0,1000,2000,3000,4000,5000,6000},{"7","6","5","4","3","2",1"})
>> > which gives the same rating for all stores. is cntl-shft required with
>> > the
>> > use of braces { }?
>> > thx
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Taking data from a row moving it to another row and sorting it.
Next: Grouping Years in a Pivot table