lookup on values between ranges

[The cat]

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

 

[Jacob Skaria]

=VLOOKUP(350,$A$2:$C$4,3,1)

If this post helps click Yes

 

[Stefi]

Values to search for being in D2
=VLOOKUP(D2,A:C,3)
Regards,
Stefi

„The cat†ezt írta:

 

[Gary''s Student]

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.

 

[Francis]

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]

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

 

[Stefi]

Only if you give False as 4th argument! Omit 4th argument!
Stefi


„The cat†ezt írta:

 

[ogerriz]

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.

 

[Francis]

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