Rang base naming in Excel.

[amitjay]

Dear All,


want to formula >> Rang base naming in excel ..

please find attach sheet.. all thing mention in sheet..

please help me..

if value between any range give me that range name..

MY DATA
RouteName Code Rates Name of Breakout
USA 48 States 1507400 0.0001 USA - C01
USA 48 States 1830319 0.0011 USA - C02
USA 48 States 1201354 0.0011
USA 48 States 1201206 0.0012
USA 48 States 1201304 0.0012



My BASE File

Rate Range Rate Range Name of Breakout
0.0001 0.001 USA - C01
0.0011 0.002 USA - C02
0.0021 0.003 USA - C03
0.0031 0.004 USA - C04

[Ace_XL]

Simply use..

=LOOKUP(C2,$I$1:$K$22)

[amitjay]

thanks for that..

but how its work .. there no range in formula ..


thanks again..