Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
I don't know if this will be a vlookup or something similar but here's what I
need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
You havnt told from where 125 came from..If your data is sorted then check
out help on the function =LOOKUP() If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: I don't know if this will be a vlookup or something similar but here's what I need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
See if this helps...
A1 = some number like 55 Lookup table in the range E1:G4 ...E.....F.....G ...0....25....21 26...50.....35 51...75.....40 76............52 =VLOOKUP(A1,E1:G4,3) Result = 40. 55 falls within the range 51 - 75 and returns the result from column G. -- Biff Microsoft Excel MVP "tjb" wrote in message ... I don't know if this will be a vlookup or something similar but here's what I need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
There are three columns of data:
A1:2930.92 A2:2954.54 A3:125 If the user enters a number (or the number is derived from another formula) that falls between the value in A1 and the value in A2, I want it to return the value from A3. "Jacob Skaria" wrote: You havnt told from where 125 came from..If your data is sorted then check out help on the function =LOOKUP() If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: I don't know if this will be a vlookup or something similar but here's what I need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
=LOOKUP(2931.15,A:A,C:C)
OR with the number in D1 =LOOKUP(D1,A:A,C:C) If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: There are three columns of data: A1:2930.92 A2:2954.54 A3:125 If the user enters a number (or the number is derived from another formula) that falls between the value in A1 and the value in A2, I want it to return the value from A3. "Jacob Skaria" wrote: You havnt told from where 125 came from..If your data is sorted then check out help on the function =LOOKUP() If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: I don't know if this will be a vlookup or something similar but here's what I need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified vlookup help
If the input is in D1, then
=IF(MEDIAN(D1,A1,A2)=D1,125,"whatever answer you want if it isn't 125) or =IF(AND(D1=A1,D1<=A2),125,"whatever answer you want if it isn't 125) -- David Biddulph "tjb" wrote in message ... There are three columns of data: A1:2930.92 A2:2954.54 A3:125 If the user enters a number (or the number is derived from another formula) that falls between the value in A1 and the value in A2, I want it to return the value from A3. "Jacob Skaria" wrote: You havnt told from where 125 came from..If your data is sorted then check out help on the function =LOOKUP() If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: I don't know if this will be a vlookup or something similar but here's what I need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Date Modified | Excel Worksheet Functions | |||
Last Modified by... | Excel Discussion (Misc queries) | |||
Last Modified | Excel Worksheet Functions | |||
Modified files | Excel Discussion (Misc queries) | |||
Modified Duration | Excel Worksheet Functions |