| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup on values between ranges
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup one value and count in two ranges | Excel Discussion (Misc queries) | |||
| Lookup table between two ranges | Excel Discussion (Misc queries) | |||
| Name ranges and Lookup | Excel Worksheet Functions | |||
| Lookup Value between 2 ranges | Excel Worksheet Functions | |||
| Ranges with in a LOOKUP | Excel Worksheet Functions | |||
Threaded Mode
