give name to range of number

[sampayor]

hi guys, i'm bit confuse about how to give the name of list of number...before this, i used lookup to give the name, but when the range of data getting larger, i'm stuck..

here's the example:

1,2,3,4,5,6,7,8,9....999999
for each 10 numbers, i'll give their names = SPICY1, SPICY2, SPICY3

this is lookup function i've used before
=LOOKUP(B1;{0,11,21};{"SPICY1","SPICY2","SPICY3"})

 

[Somendra Misra]

Hi,

What you have written above is not clear to me, can you upload a sample file with the working of what you have written above as one case and in other case what you want?

Regards,

 

[sampayor]

hi master...this is the data

 

[NARAYANK991]

Hi ,

Is there any problem with using :

=LOOKUP(A4,$E$4:$E$55,$G$4:$G$55)

Copy this down.

Narayan

 

[Hui]

In Data1!B4: ="spicy"&INT((A4-0.1)/10)+1
Copy down

On the Real Data worksheet
Mingu1 has 8 days
Mingu2, 3, 4 etc .... all only have 7 days of data ?

 

[Somendra Misra]

Doesn't this work :
in H4 and copy down:

="MINGGU "&WEEKNUM(E4)

Regards,

 

[sampayor]

Hi Master Narayan, thanks for your help..problem solved

Hi Master Hui, that's right..Minggu1 has 8 days
Your formula is great, solved the problem also.

Hi Master Somendra,
Change "week" to "minggu"....thinking out of the box..what a nice idea..

Thanks all my Masters.....thank you so much..
Very appreciate for your help

just thinkin when i'll be same level as your guys.....