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