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
|