Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- anoop ------------------------------------------------------------------------ anoop's Profile: http://www.excelforum.com/member.php...fo&userid=3066 View this thread: http://www.excelforum.com/showthread...hreadid=480341 |
#2
|
|||
|
|||
Need help on ouptput against range
=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" wrote in message ... 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 |
#4
|
|||
|
|||
Need help on ouptput against range
With your input cell D1:
=LOOKUP(D1,A1:C8) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "anoop" wrote in message ... 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 |
#5
|
|||
|
|||
Need help on ouptput against range
Thanks to all for Help. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Question for use of offset and range | Excel Worksheet Functions | |||
Question regarding dynamic range setting | Excel Worksheet Functions | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) |