Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
I need to perform a vlookup on a vaule between to values
as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
=VLOOKUP(350,$A$2:$C$4,3,1)
If this post helps click Yes --------------- Jacob Skaria "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
Values to search for being in D2
=VLOOKUP(D2,A:C,3) Regards, Stefi €˛The cat€¯ ezt Ć*rta: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
With your table starting in A1 and the lookup value in E1:
=VLOOKUP(E1,A1:C3,3) Because you have wisely chosen to sort your ranges, you don't even need to pay attention to column B values. -- Gary''s Student - gsnu200848 "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
try in E2
=VLOOKUP(D2,A2:C4,3,1) D2 is where you type 350 ...etc -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
Vlookup only returns values if that specific value appears in the first
column, as 350 is inbetween the range 301-400 and does not appear, then the return is #N/A "Francis" wrote: try in E2 =VLOOKUP(D2,A2:C4,3,1) D2 is where you type 350 ...etc -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
Only if you give False as 4th argument! Omit 4th argument!
Stefi €˛The cat€¯ ezt Ć*rta: Vlookup only returns values if that specific value appears in the first column, as 350 is inbetween the range 301-400 and does not appear, then the return is #N/A "Francis" wrote: try in E2 =VLOOKUP(D2,A2:C4,3,1) D2 is where you type 350 ...etc -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
I've just tried all their suggestions and they all work.
in the formula that you've typed in - is the last item before the ")" either false or 0? If it is then that is the reason why it isn't working. Replace that with true or 1 (but also ensure that you have already sorted the ranges out. hope this helps. "The cat" wrote: Vlookup only returns values if that specific value appears in the first column, as 350 is inbetween the range 301-400 and does not appear, then the return is #N/A "Francis" wrote: try in E2 =VLOOKUP(D2,A2:C4,3,1) D2 is where you type 350 ...etc -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
Hi
The values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value The formula provided works fine as the last argument 1 being True which will fins approximate match. Or you can omit the last argument as which mean the same =VLOOKUP(D2,A2:C4,3) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: Vlookup only returns values if that specific value appears in the first column, as 350 is inbetween the range 301-400 and does not appear, then the return is #N/A "Francis" wrote: try in E2 =VLOOKUP(D2,A2:C4,3,1) D2 is where you type 350 ...etc -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "The cat" wrote: I need to perform a vlookup on a vaule between to values as per example below, how can i get excel to return the cust name that corresponds to values between the start and end value i.e. if value was 350 return would be "cust B", 450 "cust C" etc. Start End 100 300 Cust A 301 400 Cust B 401 500 Cust C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup one value and count in two ranges | Excel Discussion (Misc queries) | |||
Lookup table between two ranges | Excel Discussion (Misc queries) | |||
Name ranges and Lookup | Excel Worksheet Functions | |||
Lookup Value between 2 ranges | Excel Worksheet Functions | |||
Ranges with in a LOOKUP | Excel Worksheet Functions |