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