Need help on ouptput against range

Dear All.

Please help on following problem
I have 8 different range as stated below.
Every range has some result Like 0 to 10 has Result A, 11 to 20 has B and so on..

Col A Col B ColC
Start End Result
0 10 A
11 20 B
21 30 C
31 40 D
41 50 E
51 60 F
61 70 G
70 100 H

Based on some input i want output based on result of above range.
E.g. If my Input is 42 then output should be E
or my input is 9 then putput should be A

How can i make some formula in worksheet to get this type of output.
Please help me on this urgently.

Regards
Anoop

=VLOOKUP(input,B2:C11,2)
for example: =VLOOKUP(42,B2:C11,2) would return E. The data in column A is
not needed for the VLOOKUP formula
Bob Umlas
Excel MVP

"anoop" <[email protected]> wrote in
message news:[email protected]...
>
> Dear All.
>
> Please help on following problem
> I have 8 different range as stated below.
> Every range has some result Like 0 to 10 has Result A, 11 to 20 has B
> and so on..
>
> Col A Col B ColC
> Start End Result
> 0 10 A
> 11 20 B
> 21 30 C
> 31 40 D
> 41 50 E
> 51 60 F
> 61 70 G
> 70 100 H
>
> Based on some input i want output based on result of above range.
> E.g. If my Input is 42 then output should be E
> or my input is 9 then putput should be A
>
> How can i make some formula in worksheet to get this type of output.
> Please help me on this urgently.
>
> Regards
> Anoop
>
>
> --
> anoop
> ------------------------------------------------------------------------
> anoop's Profile:
> http://www.excelforum.com/member.php...fo&userid=3066
> View this thread: http://www.excelforum.com/showthread...hreadid=480341
>

Hi anoop

With your criteria in A1 to C8, if you want the result in H7, try
=VLOOKUP(H7,A1:C8,3)
--
[email protected]ve_2nd_at. Stilfontein, Northwest, South Africa


"anoop" wrote:

>
> Dear All.
>
> Please help on following problem
> I have 8 different range as stated below.
> Every range has some result Like 0 to 10 has Result A, 11 to 20 has B
> and so on..
>
> Col A Col B ColC
> Start End Result
> 0 10 A
> 11 20 B
> 21 30 C
> 31 40 D
> 41 50 E
> 51 60 F
> 61 70 G
> 70 100 H
>
> Based on some input i want output based on result of above range.
> E.g. If my Input is 42 then output should be E
> or my input is 9 then putput should be A
>
> How can i make some formula in worksheet to get this type of output.
> Please help me on this urgently.
>
> Regards
> Anoop
>
>
> --
> anoop
> ------------------------------------------------------------------------
> anoop's Profile: http://www.excelforum.com/member.php...fo&userid=3066
> View this thread: http://www.excelforum.com/showthread...hreadid=480341
>
>

With your input cell D1:

=LOOKUP(D1,A1:C8)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"anoop" <[email protected]> wrote in
message news:[email protected]...

Dear All.

Please help on following problem
I have 8 different range as stated below.
Every range has some result Like 0 to 10 has Result A, 11 to 20 has B
and so on..

Col A Col B ColC
Start End Result
0 10 A
11 20 B
21 30 C
31 40 D
41 50 E
51 60 F
61 70 G
70 100 H

Based on some input i want output based on result of above range.
E.g. If my Input is 42 then output should be E
or my input is 9 then putput should be A

How can i make some formula in worksheet to get this type of output.
Please help me on this urgently.

Regards
Anoop


--
anoop
------------------------------------------------------------------------
anoop's Profile:
http://www.excelforum.com/member.php...fo&userid=3066
View this thread: http://www.excelforum.com/showthread...hreadid=480341

Thanks to all for Help.
Regards
Anoop