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